Formula for Status

Heather K
Heather K ✭✭
edited 12/09/19 in Formulas and Functions

I have a team task list sheet that has a drop-down Status column including Not Started, In Progress, Urgent, On Hold and Completed and we use card view for this. I have a % Complete column that is a text/number field and a Progress symbol column (Empty, Quarter, Half, Three Quarter & Full). 

Is there a formula that could be used in the Progress column to do the following?

If Status is Not Started or On Hold = Empty 

If Status is In Progress or Urgent = % Complete (Quarter, Half or Three Quarter)

If Status is Completed = Full




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!