How to automatically update a date column when a date has changed in another column

Cheryl Salyers

I am needing assistance with my smartsheet. I have a column that is a date column and I enter the date a project is "tentatively" going to start. I have another date column that I use to tell me on this date I need to call the client to remind them of their start date of project. Very often the "tentative" start date gets changed and I am now manually going to the date column and changing the date to make the reminder call to the client. Is there away that when the "tentative" start date gets changed is will automatically change the "reminder to call client" date column? I typically call a client 3 to 4 days prior to the start date.

I hope this makes sense. :) Appreciate any advice you can offer.

Thank you!

Cheryl

=Chris Palmer

Hello @Cheryl Salyers

If I'm understanding your needs correctly something like this might work for you:

=WORKDAY([Start Date]@row, -4)

The -4 is the days before, you can change this to 3 if you prefer.

This formula excludes weekends and will only fall on days Mon-Fri.

Make sure the in Start Date and Formula Column have their properties set to be a date.

If you want to include weekends then this will work better:

=[Start Date]@row - 4

=Chris Palmer

Hello @Cheryl Salyers

If I'm understanding your needs correctly something like this might work for you:

=WORKDAY([Start Date]@row, -4)

The -4 is the days before, you can change this to 3 if you prefer.

This formula excludes weekends and will only fall on days Mon-Fri.

Make sure the in Start Date and Formula Column have their properties set to be a date.

If you want to include weekends then this will work better:

=[Start Date]@row - 4

Cheryl Salyers

That you so much!!! That solved my problem.

Have a great day Mr. Chris!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/416784#Comment_416784

Excellent! Glad this worked for you :-)