Due Date with Conditions


I am trying to figure out how to calculate days an action is overdue.

I have calculated the due date, but can't seem to figure out how to determine if action is over due

My fields are as follows: Ackn Letter Due Date, Ackn Letter date, Days Overdue, Date Assigned

My Ackn Letter due date is set up as a formula that captures 7 days after Date Assigned. If the Ackn Letter date is blank I need it to show how many days the task is overdue - but only capturing if there is a date assigned attached to the task (otherwise it trys to grab dates, etc for my subtasks)

Date Assigned Ackn letter Due Date Ackn Letter Date Days Overue

12/05/19 12/12/19


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!