I would like to add a formula with two fields. For example: Field 1 is a dropdown menu. When I choose one in the dropdown I would like it is linked with a certain %. Is this possible? I found the workflow in suite crm. Is this the place where I can do this? I tried but didn’t work yet.
You could do this with workflow but it would be a bit long winded as you would need a workflow item for each unique %.
Another option is you could have a dynamic drop down where the child drop down would contain the % value for each of the values in the Field 1 drop down.