How to create an IF(OR()) Formula to display an alert

Hey everyone,

I am a beginner in airtable and I can’t manage to get something done:

My records are food products that all have up to 3 expiry dates, displayed in 3 date fields (Date 1, Date 2, Date 3). I then have 3 fields showing the number of days before expiry (Expiry 1, Expiry 2, Expiry 3).

So far I have only managed to create this:

IF({Expiry 1} < 30, “:warning: Need for a Promotion :warning:”, “:white_check_mark: All Good :white_check_mark:”)

But

I am trying to create a formula that would display “Need for a Promotion” if ANY of the 3 expiry dates was under 30 days from today and “All Good” if NONE of the 3 expiry dates were under 30 days.

This being beyond my skills, I ask for your kind help.
Thank you in advance!

You essentially already wrote the formula:

IF(OR({Expiry 1} < 30,{Expiry 2} < 30,{Expiry 3} < 30), "Need for a Promotion", "All Good")

1 Like

Hello Kamille, thank you so much.

I´m sure it is pretty basic but it is precisely what I was looking for.

I really appreciate the help.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.