Formulas do Percentage Row or Colum
Hello, I need some help. I'm trying to create a formula that if the status row is 100 %, the status row will change to "complete", and if it less than 100% = "in progress" and 0%= "not started" Also I'm not using any dependencies?
Best Answer

Try this. I have a field called status that contains this formula. It looks at the field called "% Complete" on the same row.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
When something is 100% complete, the value is 1, so the first argument would set it to complete. If that is not true, then it looks to see if it is greater than 0 and sets it to in progress. Otherwise, it will set it to not started by default.
Answers

Try this. I have a field called status that contains this formula. It looks at the field called "% Complete" on the same row.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
When something is 100% complete, the value is 1, so the first argument would set it to complete. If that is not true, then it looks to see if it is greater than 0 and sets it to in progress. Otherwise, it will set it to not started by default.


Thank you Clydene. Now you make my b so easy

Glad to help.
Help Article Resources
Categories
Check out the Formula Handbook template!