# Follow-up Status

Topic Labels: Formulas
Solved
1331 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hey everyone!

I had help with a formula not too long ago, and I’ve simply tweaked it to apply to other tables… but as of now, I’m not getting the results I need.

Here’s the formula:
`IF(`

` {Date},`

` IF(`

` Date > TODAY(),`

` IF(`

` DATETIME_DIFF(Date, TODAY(), "days") <= 30,`

` "30 days", "1 month",`

` IF(`

` DATETIME_DIFF({Date}, TODAY(), "days") <= 180,`

` "180 days",`

` "6 months"`

` )`

` ),`

` "Send 6 month status check email"`

` ),`

` "Send 30 day status check email"`

`)`

Every status is showing as “Send 6 month status check email” even if it’s within 30-days. Help?

And can anyone offer resources for the clueless when it comes to building formulas (outside of the Airtable cheat sheet)? I would definitely appreciate the help.

1 Solution

Accepted Solutions

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"
)
)
)
``````
4 Replies 4
18 - Pluto

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.

5 - Automation Enthusiast

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"
)
)
)
``````
5 - Automation Enthusiast

This works perfectly and is exactly what I needed! You’re amazing, and I appreciate your help so much!!! :raised_hands: