30-Day Prompt

Dana L

Hello,

I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017.  Can someone help with the formula for that?  (Column A would be "Task" and Column B would be "Start Date".  I'd like Column C to be "Action Date."

There's a few different triggers that I need to create for each line, so this will be so helpful.  Thank you!

J. Craig Williams

In Column C

=[Start Date] - 30

Set up a Reminder using Column C and "on" that date.

https://help.smartsheet.com/articles/542913-using-reminders

When you set up your first Reminder, you'll notice there are other options besides "on" ... but 30 days is not one of them, so Column C is necessary. It won't always be.

Lastly, if the Action Date is in the past, it won't send you a notification.

I hope this helps.

Craig

Mike Wilday

Craig's solution is one we have used a multitude of times. 

Dana L

Thank you!  But is there no way to automatically have that "action date" calculated?

I have about 100 "tasks" (each representing a client) where I want it to automatically calculate the "action" date.

 

Many thanks...

Mike Wilday

Craig's solution of creating a column that calculates the date is calculating the date. There is no way in the reminder system to calculate 30 days. I believe the most they give you is 14 days. So calculating the date in the new column will do the trick for you. If you create a new column and add the formula that Craig mentioned, then you can drag the right-hand corner down to autofill each of your 100 of tasks.