Task Status Autofill based on % Complete and On Hold Flag

Troy G

Hello,

I would like to autofill my task status column to "Not Started", "In Progress", "Completed", or "On Hold". Not started, In progress, and completed would be based off a completion %, and On Hold would be based off a flag called "On Hold". I would like to keep this flag so we can use it for roll ups in our dashboards if possible.

"Not Started", "In Progress", "Completed" can be completed using function =IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress"))

"On Hold" can be completed using function =IF([On Hold]@row = 1, "On Hold")

Can anyone let me know of a way to say use % completed unless On Hold flag is set and then always use "On Hold" as Status until flag is cleared?

Nic Larsen

Try this: =IF([On Hold]@row = 1, "On Hold", IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress")))

Nic Larsen

Try this: =IF([On Hold]@row = 1, "On Hold", IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress")))

Troy G

@Nic Larsen Thanks so much for the help on this issue. Worked like a charm!