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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!