Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Reminder formula for 30 days time

Topic Labels: Formulas
Solved
Jump to Solution
387 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there!

I’m looking to create a formula that will set a trigger for a reminder in 30 days time from an activity, when it will display “Trigger Reminder” after 30 days have passed from that live date field.

I thought this formula would work:

IF(AND(DATETIME_DIFF(TODAY(), {Live Date}, ‘days’ > 30)), “Trigger Reminder”)

But that just comes up with Trigger Reminder for pretty much everything in my base.

Any help welcomed! Thanks!

J

1 Solution

Accepted Solutions

Hi Josephine. I think you made it just a little more complicated than it needs to be.

IF(DATETIME_DIFF(TODAY(),{Live Date},'days') > 30, 'Trigger Reminder')

Good luck!

See Solution in Thread

2 Replies 2

Hi Josephine. I think you made it just a little more complicated than it needs to be.

IF(DATETIME_DIFF(TODAY(),{Live Date},'days') > 30, 'Trigger Reminder')

Good luck!

You’re so right… I was way overthinking. Thanks!