Auto Populate Dates

edited 12/09/19 in Formulas and Functions

Hi All,

I have a smartsheet and am unsure the work arounds with date formulas. I have two columns one referencing when a task should be completed and one with an actual delivery date of task. I am trying to enter in something to auto populate dates for these tasks based on the initial start off date. 

Can anyone help me with this? I'd appreciate it! I also attached a photo. 


(Currently actual delivery date is a date column)

Ultimate Customer Experience - Smartsheet.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!