IF statement

System
Employee
This discussion was created from comments split from: Is there a formula to update the status based off the % complete?.
Answers
-
I copied this directly and for some reason it still says "In Progress" any ideas on what is going on?
-
hi,
instead of 100, just have 1 (it's a percentage, so 100% = 1).
In your case, you don't need the last IF by the way.
BR
FZ
-
Hello @Tia_D,
Good day! Just tagging you in case you missed the response from Florian!
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao! π | Global Discussions
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!