Skip to main content

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

  • January 23, 2020
  • 2 replies
  • 41 views
A

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!

    This topic has been closed for replies.

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    You essentially already wrote the formula:

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

      A
      • Adrien_BOUSSIER
      • Author
      • New Participant
      • January 23, 2020

      You essentially already wrote the formula:

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


      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.

      Terms & ConditionsAccessibility statement