Formulas for Column Dates to Autofill

Hello there,

I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline.

I am trying to figure out how to set it up so that the Project Auditor Completion Deadline will auto populate with a date 14 days our from the Project Owner Actual Completion Deadline. For example is the owner actually completed the project on 8/1/2020 I would like the auditor completion deadline to generate at 8/15/2020.

Can anyone provide help with this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!