If Then Formula Not Producing Result

MLS

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!

Steven Sachs

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

MLS

tried that but no luck

Kleerfyre

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%.