We are using % Complete column to drive our Status column value. I have tried -1 and -2 but not sure how to determine what % Complete should be in order for us to change the Status value to Archive or Backlog.
Any ideas?
My formula looks like this:
=IF(ISBLANK([% Complete]@row), "",
IF([% Complete]@row = -2, "Archive",
IF([% Complete]@row = -1, "Backlog",
IF([% Complete]@row = 0, "1. Approved",
IF([% Complete]@row = 1, "8. Completed",
IF(AND([% Complete]@row > 0, [% Complete]@row < 0.25, Category@row <> "Discovery"), "3. Discovery",
IF(AND([% Complete]@row > 0, [% Complete]@row < 0.65, Category@row <> "Discovery"), "4. Development",
IF(AND([% Complete]@row > 0, [% Complete]@row >= 0.65, Category@row <> "Discovery"), "6. Testing",
IF(AND([% Complete]@row > 0, [% Complete]@row < 1, Category@row = "Discovery"), "3. Discovery"
)
)
)
)
)
)
)
)
)
