Calculate Status Column by %Complete

Joe Wills

Trying to set status column based on % complete - I can make the formula work with just the first statement - =IF([% Complete]@row = 0, "Not Started")

=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row >= 1 < 100, "In Progress", IF([% Complete] = 100, "Complete")))

Anyone know how to make the above formula work?

Thanks!

Mike Raposo

When writing formulas for a % Complete you have to use the decimal form of the value in the formula. Additionally, in order to check against multiple conditions you have to use the AND() function. This formula should work:

=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row >= 0.01, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))

Let me know if you have any questions!

Hope this helps!

Mike

Mike Raposo

When writing formulas for a % Complete you have to use the decimal form of the value in the formula. Additionally, in order to check against multiple conditions you have to use the AND() function. This formula should work:

=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row >= 0.01, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))

Let me know if you have any questions!

Hope this helps!

Mike

Joe Wills

@Mike Raposo - Ah that makes sense, it did the trick. Thanks a bunch!