If Then Formula Not Producing Result
I'm trying my first formula, and simply want to check a status field, and if the status = Pass then return a 100% in the % Complete column. I wrote the following formula in the '% Complete' field. The formula displays but not a value: =IF([SAT 4 Test Result]@row = "Pass", 100, 0). Is the formula wrong or do I need to do something else to make the formula calculate and display the result?
Thank you!
Answers

Maybe add a "+ 0 to the end of your formula to force smartsheet to see it as a value

tried that but no luck

If it is a percent column, then you have to change your 100 to 1 to have it show as 100%. Percent columns use 1 as the whole and to get like 95%, you would have to put in .95 for it to return 95%.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
Check out the Formula Handbook template!