Changing Status to a number in order to chart


Hello! I am needing to make a widget in a dashboard t show the number of "complete, not started, or in progress" items I have. I know I need to change the status to a number. I have tried to do this with "IF logic but am failing. Can someone help with a formula for the following case?

If status is Not Started = 1

If status is In Progress = 2

If status is Completed = 3

Thank you!!!

if case.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!