How to automatically generate a Date that's three weeks later than a given Date in another column?


I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type).

The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually entered Dates in "Response Due Date" column so i only want to apply this to the future rows.

Thank you for your help in advance. It's very much appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!