Help

IF AND Formula Help!

Topic Labels: Formulas
Solved
Jump to Solution
225 2
cancel
Showing results for 
Search instead for 
Did you mean: 
KGB
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

Screenshot 2024-06-20 at 10.54.43 PM.png

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

Screenshot 2024-06-20 at 10.54.43 PM.png

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

Thank you!!