Hey Tender, what do you want the formula to output here? I can’t really make sense of your formula and would rather just write a new one for you.
Hey Tender, what do you want the formula to output here? I can’t really make sense of your formula and would rather just write a new one for you.
Hey Adam!
Bit of background, non-profit that provides emergency bill pay support… We want to follow-up with those that have made specific financial requests in 30 day, 180 day and 12 month intervals. I want the status to update based on the original request date to trigger email automation.
Hey Adam!
Bit of background, non-profit that provides emergency bill pay support… We want to follow-up with those that have made specific financial requests in 30 day, 180 day and 12 month intervals. I want the status to update based on the original request date to trigger email automation.
Thanks for the details! I’ve pasted a formula below that you can try, and here’s a screenshot of it in action:

- If it’s been at least 30 days and less than 180 days, it’ll show “Send 30 day status check email”
- If it’s been at least 180 days and less than 365 days, it’ll show “Send 6 month status check email”
- If it’s been at least 365 days, it’ll show “Send 1 year status check email”
Let me know if you need any changes!
IF(
AND(
DATETIME_DIFF(TODAY(), {Date}, "days") >= 30,
DATETIME_DIFF(TODAY(), {Date}, "days") <= 179),
"Send 30 day status check email",
IF(
AND(
DATETIME_DIFF(TODAY(), {Date}, "days") >= 180,
DATETIME_DIFF(TODAY(), {Date}, "days") <= 364),
"Send 6 month status check email",
IF(
DATETIME_DIFF(TODAY(), {Date}, "days") >= 365,
"Send 1 year status check email"
)
)
)
This works perfectly and is exactly what I needed! You’re amazing, and I appreciate your help so much!!!