If or and formula help

Lily08

Hi,

Can anyone help with this formula? I'm stumped!

If (Second Apparatus) contains "PM01" or "LD01", and (Agency) contains "TFD," then populate "TFD Battalion 1"

=IF(OR(AND([Second Apparatus]@row = "PM01", ([Second Apparatus]@row = "LD01")), AND(Agency@row ) = "TFD"), "TFD Battalion 1", "")

Thank you!

Kelly Moore

Hey @Lily08

IF(AND(Agency@row = "TFD",OR([Second Apparatus]@row= "PM01",[Second Apparatus]@row= "LD01")),"TFD Battalion 1")

Does this work for you?
Kelly

Sam_Harwart

https://community.smartsheet.com/discussion/139971/if-or-and-formula-help

Hi @Lily08

Try this if you mean to use "contains" in the sense that you're looking for the given text within the entire cell:
=IF(AND(OR(CONTAINS("PM01", [Second Apparatus]@row ), CONTAINS("LD01", [Second Apparatus]@row )), CONTAINS("TFD", Agency@row )), "TFD Battalion 1", "")

Or this if you mean the value is exactly the specified text:
=IF(AND(OR([Second Apparatus]@row = "PM01", [Second Apparatus]@row = "LD01"), Agency@row = "TFD"), "TFD Battalion 1", "")

Lily08

Thank you @Sam_Harwart and @Kelly Moore

It actually worked by changing

=IF(OR(AND

to

=IF(AND(OR

Sam_Harwart

https://community.smartsheet.com/discussion/comment/487198#Comment_487198

That's great! Happy to help.