Autofill if a column contains vs. if true or false

zszostak

trying to figure out if/how i can make a sheet auto fill a column based "if contains" not "if true"/"if false"

Ex: Door Schedule for production

Column to report on = Door Size

Reporting Column = Drop down of hinge counts

If "Door Size" contains "8-0" - Hinge Counts = 4

If "Door Size" contains "7-0" - Hinge Counts = 3

What would that Formula be?

Find more posts tagged with

logic

Accepted answers

All comments

Kelly Moore

Hey @zszostak

I'm assuming only the number needs to go into the Hinge Counts column and not the number + text. The formula should reside in the Hinge Counts column.

=IF([Door Size]@row="8-0", 4, IF([Door Size]@row="7-0", 3))

If "8-0" is the complete textstring in your Door Size column, you do not need to use the CONTAINS function. If the "8-0" is only part of the the textstring, ex; "8-0 partnumber ABC", then yes, you could use the CONTAINS function.

If you must use the CONTAINS function

=IF(CONTAINS("8-0", [Door Size]@row), 4, IF(CONTAINS("7-0", [Door Size]@row),3))

Let me know if you also need the text and I'll show you how to modify the formulas above.

Kelly

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.