Skip to main content
Solved

IF/OR Statement involving a single select field

  • February 25, 2022
  • 2 replies
  • 38 views
Shawntel_Cote
Forum|alt.badge.img+5

I’m looking to create a datestamp field based on if a Single Select field is either COMPLETE or CANCELED, otherwise it should remain empty.

I’ve searched through this site and tried a variety of options but have had no success.

IF(OR(Status=“COMPLETE”,“CANCELED”,LAST_MODIFIED_TIME())) **This returns all cells as blank

Thanks in advance!

Best answer by Kamille_Parks11

Since you put the timestamp within the OR and you haven’t connected ‘cancelled’ to the field {Status}, you’re asking “if {Status} = ‘COMPLETE’, if the phrase ‘CANCELED’ is not blank, or if the record has ever been modified”. That is guaranteed to always be “true” since the phrase ‘CANCELED’ has a value. Your formula does’t output anything for “true” or for “false”. The proper formula would be

IF(
OR(Status="COMPLETE", Status="CANCELED"),
LAST_MODIFIED_TIME()
)

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

Since you put the timestamp within the OR and you haven’t connected ‘cancelled’ to the field {Status}, you’re asking “if {Status} = ‘COMPLETE’, if the phrase ‘CANCELED’ is not blank, or if the record has ever been modified”. That is guaranteed to always be “true” since the phrase ‘CANCELED’ has a value. Your formula does’t output anything for “true” or for “false”. The proper formula would be

IF(
OR(Status="COMPLETE", Status="CANCELED"),
LAST_MODIFIED_TIME()
)
Justin_Barrett
Shawntel_Cote
Forum|alt.badge.img+5
  • Shawntel_Cote
  • Author
  • New Participant
  • February 25, 2022

Since you put the timestamp within the OR and you haven’t connected ‘cancelled’ to the field {Status}, you’re asking “if {Status} = ‘COMPLETE’, if the phrase ‘CANCELED’ is not blank, or if the record has ever been modified”. That is guaranteed to always be “true” since the phrase ‘CANCELED’ has a value. Your formula does’t output anything for “true” or for “false”. The proper formula would be

IF(
OR(Status="COMPLETE", Status="CANCELED"),
LAST_MODIFIED_TIME()
)

Thanks that worked! I tried so many options that I had lost count of the variations. :slightly_smiling_face:
I can’t believe I missed this one as it makes so much sense.

Terms & ConditionsAccessibility statement