Solved

IF AND Formula Help!

Forum|Forum|1 year ago
June 20, 2024
2 replies
35 views

+3

KGB
Participating Frequently

Hello!

I have two fields that I want to meet certain criteria to return a value in another field.

Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date field is empty have this field stay empty

Thanks!

Best answer by TheTimeSavingCo

Does this look right?

IF(
  {Date/Timestamp},
  IF(
    {Advanced Record} = "ADVANCED",
    IF(
      DATETIME_FORMAT(
        {Date/Timestamp},
        "HH"
      )>21,
      "Late",
      "On time"
    )
  )
)

+31

TheTimeSavingCo
Brainy
Answer
Forum|Forum|1 year ago
June 20, 2024

Does this look right?

IF(
  {Date/Timestamp},
  IF(
    {Advanced Record} = "ADVANCED",
    IF(
      DATETIME_FORMAT(
        {Date/Timestamp},
        "HH"
      )>21,
      "Late",
      "On time"
    )
  )
)

Adam, Airtable Consultant - thetimesaving.company