Formula with multiples parameters

Topic Labels: Formulas
296 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey everyone! 

Can you help me to figure it out how to properly write this formula?


Both Result, And Goals are Columms in my table. 

Thank you all, in advance! 

1 Reply 1

depends on what is Goal..  ?  Is it number formatted as percent? Or just text field? What if Goal is 110%? 90%?
or is it Single select with limited options? If you mean  that whole range between 80 and 120 is 'Completed', then why do you need 100?