Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Need help on formula

467 0
cancel
Showing results for 
Search instead for 
Did you mean: 
F_M
4 - Data Explorer
4 - Data Explorer

Right now we have a formula that uses percentages based on timeliness (Auto Calculated Percentage). This value is determined through a set of time between two dates. However I’d like to be able to override that for certain employees using another field like a checkbox or maybe a number field. So maybe an if statement would go in the auto calculated percentage? Like if override field is blank then use auto calculated percentage field? I can’t figure out how to do it

({Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}

1 Reply 1
momentsgoneby80
7 - App Architect
7 - App Architect

Hi @F_M!

IF() formulas work as follows:

IF({condition is true/has a value},
   {do this},
   {otherwise do that}
)

In your case you need to create your new field of choice and then add an IF() statement to your original formula. This should do it.

IF({name of new field of choice},
    	{name of new field of choice},
    	{Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}
)

(You have a random ‘(’ at the beginning of your formula. Check to see if this is a mistake just in your question post or if not all of your original formula was copied. Make sure that you use the whole of the original formula in your IF()-statement for it to work as desired.)