if statement

Jimmy

Hi,

Can someone help me on this formula.

Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No.

 

 

Andrée Starå

Hi Jimmy,

It will work if you change the 100 to 1.

Smartsheet looks at the numbers in a column formatted for percentage (for example, a % Complete column) as values between 0 and 1. Use decimal values (examples: 0.25 for 25%, 0.5 for 50%) to get the correct comparison, as opposed to whole numbers.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jimmy

Awesome..Thanks Andree

Andrée Starå

Happy to help!

Best,

Andrée