# IF Status / % Complete / Progress

✭✭

I have a Project Tracking list sheet that has a

Drop-down Status column including At Risk, Pending, In Progress, and Complete; we use card view for this.

% Complete column that is a text/number field, and

Progress symbol column (Empty, Quarter, Half, Three Quarter & Full).

Is there a formula that could be used in the % Complete and Progress columns to do the following?

If Status is At Risk = 0% in the %Complete Column and Empty in the Progress Column

If Status is In Progress = 50% Complete and Quarter in the Progress Column

If Status is Pending = 75% complete and Three Quarter in the Progress Column

If Status is Complete = 100% Complete and Full in the progress Column

Thank you so much for helping me!

Loretta

• ✭✭✭✭✭✭

For the % Complete Column:

=IF(status@row = "At Risk", 0, IF(status@row = "In Progress", 0.5, IF(status@row = "Pending", 0.75, IF(status@row = "Complete", 1, ""))))

For the Progress Column:

=IF(status@row = "At Risk", "Empty", IF(status@row = "In Progress", "Quarter", IF(status@row = "Pending", "Three Quarter", IF(status@row = "Complete", "Full", ""))))

• ✭✭✭✭✭✭

For the % Complete Column:

=IF(status@row = "At Risk", 0, IF(status@row = "In Progress", 0.5, IF(status@row = "Pending", 0.75, IF(status@row = "Complete", 1, ""))))

For the Progress Column:

=IF(status@row = "At Risk", "Empty", IF(status@row = "In Progress", "Quarter", IF(status@row = "Pending", "Three Quarter", IF(status@row = "Complete", "Full", ""))))

• ✭✭

It totally worked! Thank you Soooo Much!!! You MADE MY DAY!!! 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!