Sign in to join the conversation:
Kia ora everyone,
Couldn't find anything relating to this question, but feel it can't be the first time asked :-)
I'd like to have an alert on a date column, so that 30 days prior to that date we are notified.
Is this possible?
Thanks,
Brendon
Hi Brendon,
You can set this up in the "Alerts & Actions" menu --> "Set a reminder", but there are only settings for max 14 days before so what I usually do is that I add a column that specifies how many days before that I want the reminder to trigger and then in the date column I add a formula like the one below. Keep in mind that this will count all days.
=[Date Column]@row - [Days before reminder Column]@row
More info: https://help.smartsheet.com/articles/542913-using-reminders
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
I learned something (kia ora)
Craig
Ngā mihi nui Andrée,
Trying your solution, I must be doing something wrong? I have tried without the brackets, and also tried 'Reminder Date' as a text field and a date field. (Exp is a date field)
Screenshot here
goo.gl/QgVW1f
Your link does not work.
It may not be clear, but Andrée's solution:
=[Date Column]@row - [Days before reminder]@row
requires TWO new columns. One that houses the Date (a Date type column, used in the Alert) and the [Days before reminder] which is a Text/Number type column with the number of days (30 in your stated case)
This is (I assume) for flexibility if some tasks are 30 days, some 45 and so on.
You could also change the formula to
=[Date Column]@row - 30
and skip the second column entirely.
Maybe that helps? I had to reread his answer to get that too.
Did you get it working?
Andrée
I tried to sign into my Smartsheet portal it asked for an authenticator code. I don’t have one and I can’t find the QR code to authenticator to my own Microsoft authenticator app. Can anyone help me?
Hello. I need to send a sheet to multiple different people and I want them to only be able to interact with their specific row. Is this possible? eg: 10 rows(person A, comment) I want Row 1 to go to person A and for them to only see their row and only comment in their specific section, Row 2 → person B, etc, etc. Any help…
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…
