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

Cheryl Salyers
Cheryl Salyers ✭✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Best Answer

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

    image.png


    image.png

    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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!