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.
Thank you!
Cheryl
Best Answer
-
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
https://www.linkedin.com/in/zchrispalmer/
Answers
-
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
https://www.linkedin.com/in/zchrispalmer/
-
That you so much!!! That solved my problem.
Have a great day Mr. Chris!
-
Excellent! Glad this worked for you :-)
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!