Recurring Weekly Tasks Formula

Wes S
Wes S
edited 12/09/19 in Formulas and Functions

I have a sheet set up with a weekly task, a column for last completed date, and a column for next due date. I have a column that indicates the day of week that it must be completed on.

I am trying to set up a formula in the next due date column that uses the selected day of week to update the next due date based on the last completed date. Something like: =IF(TODAY() > [last completed date], next WEEKDAY([day of week due])) 

I'm just having trouble figuring out how to express the value if true portion of the formula. 

Thanks in advance for your help.


Screen Shot 2019-06-19 at 1.22.49 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!