regarding Auto Calculate Today date

Heshy Tauber

Hi 

 

I Am Trying to set a Notification on a Collection sheet that i track Collection notes and Promised date when the customer Promised to pay now i have a date column which i type the date we need to call back the customer 

 

but is their a way to make auto Notifications any date that is past "today "

 

Meaning to say if i set we have to call back the customer for $ 03/29/2017 and i call on the 29th and i cant get through to the customer i want the next date to remind me again 

 

Or maybe i can make another column date if original date column is today or past today set todays date so i can make notifications to the 2nd column 

 

any ideas ?

Shaine Greenwood

Hi Heshy,

 

It looks like you're wanting ot set a Reminder that emails you a certain number of days after a date in your sheet. Note that:

 

-Notifications in Smartsheet email you when specific changes have been made in the sheet.

-Reminders email you based on a date (before, after, or on a date).

 

Use the steps in the Help Center to set up Reminders: https://help.smartsheet.com/articles/542913-using-reminders

 

You can only create Reminders for up to 14 days after a date in your sheet. If you need MORE than that, then you'll definitely want to go with that option you mentioned and add a second date column, then base the reminder on that date.

 

A neat trick you can use to automate this is to add a formula to the second date column that adds a number of days from your first date column, such as the following example (you'll need to change the example cell reference such that it matched your date column):

 

=[Call Date]1 + 30

 

The above adds 30 days to the date.

 

More on formulas can be found here: https://help.smartsheet.com/articles/775363-using-formulas

Heshy Tauber

Hi thanks from reply but i can't know exactly how many days I need 

 

Since the 1st date is  calculate from last payment date +10 days 

 

so i need a formula to auto calculate "Today" date if the first date Column is in the Past ?