Dynamic Due Date based on Multiple Criteria
I'm seeking to have a column that would dynamically update a task [Due Date] based off multiple conditions. Our current sheet setup has [Original Due Date], [Extension Due Date], [Extension] this is a check box, and [Planned Completion Date].
[Original Due Dates] = defined by governing body
[Extension Due Date] = defined by governing body, with approval
[Extension] = check box, yes/no has the task been extended
[Planned Completion Date]= This is our firm's planned completion date or when we should target to complete the task based off dependencies.
The [Original Due Date] & [Extension Due Date] would be listed on a separate sheet with Original due dates and extension dates from the governing body for each task.
Is there a feature or perhaps a combination formula (perhaps IF + LookUp? or maybe Collect?) that would look at [Task] column and return the [Original Due Date] or the [Extension Due Date] based off the task name and the [Extension] criteria?
Help Article Resources
Check out the Formula Handbook template!