IF statement with two possible outputs

Hi there,

I'm trying to populate a cell/column with a couple scenarios:

Column names: "Region/Country", "Wine", "Vintage", and "For copy-paste"

If the Region/Country = "Champagne", then the "For copy-paste" cell should populate with Region/Country + Wine + Vintage.

If the Region/Country is anything but Champagne, then the "For copy-paste" cell should be simply Wine + Vintage.

Please help! Thanks so much.

Find more posts tagged with

Accepted answers

All comments

Dan W

If the Region/Country is Champagne, and lets say the wine and Vintage are "1"

this formula will display: Champagne-1-1

=IF(HAS([Region/Country]@row, "Champagne"), [Region/Country]@row + "-" + Wine@row + "-" + Vintage@row, Wine@row + "-" + Vintage@row)

You can edit the "-" to whatever you like to fit how you want it to read. Such as changing them to "/" to read: Champagne/1/1. Removing the - but leaving a space " " will display: Champagne 1 1

Sandy Glassberg

That worked like a charm! Thank you so much!

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.