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

Nezar Loukili

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.

Lucas Rayala

https://community.smartsheet.com/discussion/122724/how-to-automatically-generate-a-date-thats-three-weeks-later-than-a-given-date-in-another-column

I would move your current responses to a new date column called "Override". Then, create a column formula in your "Response Due Date" column as follows:

=IF(NOT(ISBLANK(Override@row)), Override@row, [Creation Date]@row+21)

If you have a previously entered date in Override@row (for dates you copied over), this formula will default to that date. Otherwise, it will create a date that is 21 days (3 weeks) after the date in the Creation Date column. The Override column will also allow you to manually adjust any future due dates if necessary.