If Then Formula Not Producing Result

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!