IF CONTAINS Help!

Lisa B 2022

Good morning,

I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.

Effectively, can I use multiple criteria with multiple results?

So the single formula works fine =IF(CONTAINS("Advertising", Activity@row), 45, "")

But I then want to look for Operations and return a value of 30.

Anyone any suggestions?

Thanks!

Lisa

Find more posts tagged with

Formulas

Accepted answers

Kaveri Vipat

Hi Lisa B 2022,

You can try this formula for your condition-

=IF(CONTAINS("Advertising", Activity@row), 45, IF(CONTAINS("Operations", Activity@row), 30, ""))

All comments

Kaveri Vipat

Hi Lisa B 2022,

You can try this formula for your condition-

=IF(CONTAINS("Advertising", Activity@row), 45, IF(CONTAINS("Operations", Activity@row), 30, ""))

Lisa B 2022

https://community.smartsheet.com/discussion/comment/388395#Comment_388395

Thank you so much, I was trying to put further criteria outside of the bracket! Much appreciated!

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.