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