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!
Does this look right?
IF(
{Date/Timestamp},
IF(
{Advanced Record} = "ADVANCED",
IF(
DATETIME_FORMAT(
{Date/Timestamp},
"HH"
)>21,
"Late",
"On time"
)
)
)
Thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.