If Formula with a Dropdown List
I have a column titled Status that includes the following drop down selections: Not Started, In Progress, On Hold and Complete. I want to write a formula that based on the drop down selected, another row would populate the following automatically:
Not Started = 0%, In Progress = 50%, Completed = 100% and On Hold = ON HOLD. I have tried a number of formula calibrations and keep getting UNPARSABLE in my cell.
Looking for suggestions.
Help Article Resources
Check out the Formula Handbook template!