if statement

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.
Β
Β
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Awesome..Thanks Andree
-
Happy to help!
Best,
AndrΓ©e
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!