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

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!