+1Hi 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
Best answer by augmented
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!
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!
+1Hi 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
