Hello, I'm working on a formula that will trigger a status of "complete" based on a Task Reviewed column.
=IF([Task Reviewed]5883 = 1, "Complete", PARENT())
I am trying to combine the formula with another one that will trigger the same status as the parent row when the cell above it is complete.
=IF(Status5882 = "Complete", PARENT(), "")
The end goal is to have the priority cascade to the next row when the task has been reviewed. The due date and task assigned check box are triggered based on the priority, which is based on the parent row and the time between column.
Can someone let me know if this is possible to have my cake and eat it too? Thank you!