The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jun 14, 2019 01:23 PM
hello all!
I don’t know if it is possible but this is what I would like the column to do.
So it’s going to be based off the “Insurance Date” . column
I would like to set a formula to where it’s the day of or a couple days before the Insurance Date, I want to be told that “renewal needed” and otherwise say “OK” .
I had this but the system is saying it’s not a good formula
IF((IS_BEFORE{INSURANCE DATE=TODAY()}, “GOOD”,“RENEWAL NEEDED”))
and then if it’s possible that when the result in first formula is “Renewal needed” , if it would trigger an alert to a person(s) that renewal is needed. Is there a way to assign a task in a If statement?
Jun 14, 2019 01:46 PM
Hi there!
The following formula will return “Renewal Needed” on or up to three days before {Insurance Date}.
IF(OR(AND(IS_AFTER(TODAY(), DATEADD({Insurance Date}, -3, 'days')), IS_BEFORE(TODAY(), {Insurance Date})), IS_SAME(TODAY(), {Insurance Date})), "Renewal Needed", "OK")
Alternatively, the following will also return “Past Due”, if today is after {Insurance Date}.
IF(IS_AFTER(TODAY(), {Insurance Date}), "Past Due", IF(OR(AND(IS_AFTER(TODAY(), DATEADD({Insurance Date}, -3, 'days')), IS_BEFORE(TODAY(), {Insurance Date})), IS_SAME(TODAY(), {Insurance Date})), "Renewal Needed", "OK"))
As for the alerts, I would recommend using Zapier! Learn more here:
Jun 18, 2019 07:56 AM
you are awesome! Thank you for answering! :slightly_smiling_face: