IF(Contains)

I am using the IF(Contains formula to look at values in the Numbers to Include column, which is a multi-select drop down column, and it if finds the value to add a number to the Office Phone column.

=IF(CONTAINS("Main Office: 303-932-0757", [Numbers to Include]@row, "303-932-0757", ""))

This formula is in the Office Phone cell for the current row.

I am getting an Incorrect arguments error.

Find more posts tagged with

Accepted answers

Becky Wilson

Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.

All comments

Becky Wilson

Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.

Marcela

Awesome to hear you found a response, @Becky Wilson!

Please feel free to post your solution as well.

Cheers!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.