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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!