I've been asked to lock the "Status" column and only allow changes to the "% Complete" field by the assigned task owners. This admittedly will limit the use of all the status' as I'm trying to develop a strategy to simply change my approach and limit the functionality options.
My Status column should ideally include the options for Not Started, In Progress, Ready to Work, On Hold, Complete, Cancelled.
The code currently in the Status column is not complete and is
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
The helper column in the row+1 location, helper5 is
=IF(INDEX(Status:Status, MATCH([Task Name]@row , [Task Name]:[Task Name], 0) - 1) = "Complete", 1)…. This returns a value of 1 when the previous step is 100% complete
The formula in the row column is
=IF([helper5]@row = 1, "Ready to Work", IF([% Complete]@row = 0, "Not Started", "In Progress"))
ideal conops; when the previous step is 100% complete the next steps status will change to 'Ready to Work', then when the % complete is changed to something between 0%-99.9% it would state "In Progress", then when complete state 100% = complete, then the next step would go to 'Ready to Work', etc. The way the code is currently behaving when the % complete of the task is any number the status always returns ' ready to work'.
The next phase would be to understand a trigger at the matching row to send the person in the 'assigned to' column that their step is ' ready to work'.
I don't see much on the community as discussions on how to address notifying task owners. Any suggestions on how you've address something similar or suggestions would be greatly appreiated.
