Help calculating the state (Status) column so I don't have to manually update it

Irina

Here is the formula I am using:

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

The "Not Started" and "In Progress" work well, but not the 100% complete.

Mark Cronk

Hi Irina,

Try:

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

Mark

Mark Cronk

Hi Irina,

Try:

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

Mark

Irina

Thank you so much @Mark Cronk that was extremely easy to fix. I thought it was expecting the actual value I was passing (100). Thank you!!

Mark Cronk

Happy to help. Thank you for contributing to the Community.

Mark