How to automatically update a date column when a date has changed in another column
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.
Help Article Resources
Check out the Formula Handbook template!