How to have my status reflect a percentage complete

Jpurdom ✭✭
edited 01/11/23 in Formulas and Functions


Column B has my dropdown option of Statuses (Complete, In Progress, Waiting, Not Started, & Escalated) Complete = 1, In Progress= .75, Escalated .5, Waiting= .25, and Not Started = 0

Column C is a percentage.

I would like to have Column C automatically update when column B has a dropdown selected.

Current formula =IF(Status@row = "Complete", 1, IF(AND(Status@row = "In Progress", 0.75)))

I am receiving an Unpareseable error.

Please help 😦


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!