What formula to use in Status column based on % Complete column?
Hi, I'm stumped...I've tried this formula multiple different ways and nothing seems to work.
Status column: Not Started, In Progress, or Complete
% Complete column: any number (column is set to %'s)
This is what I need: IF % Complete = 0, Status=Not Started, IF % Complete is greater than 0 and less than 100, Status=In Progress, IF % Complete = 100, Status=Complete.
This is the last example of what I tried=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 100), "In Progress", IF([% Complete]@row = 100, "Complete")))
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!