If or and formula help

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!

Find more posts tagged with

Accepted answers

All comments

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

=IF(AND(OR

Sam_Harwart

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

That's great! Happy to help.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.