Hello, I am trying to build a formula that assesses several columns and returns results as a list. Kind Helpful Polite Cheerful Attentive Good Ok NeedsWork 5 4 3 2 1 Kind Helpful Polite Cheerful Attentive =TEXTJOIN(@, ",TRUE,IF(A@>4,"Kind",""),IF(B2>4,"Helpful"…..etc. works in Excel but I haven't been able to convert it to the correct syntax for Smartsheet. I'd prefer to do it without helper columns as I am evaluating multiple items. Is there something that will work?

Converting Excel Formula

Hello,

I am trying to build a formula that assesses several columns and returns results as a list.

Kind	Helpful	Polite	Cheerful	Attentive	Good	Ok	NeedsWork
5	4	3	2	1	Kind Helpful	Polite	Cheerful Attentive

=TEXTJOIN(@, ",TRUE,IF(A@>4,"Kind",""),IF(B2>4,"Helpful"…..etc. works in Excel but I haven't been able to convert it to the correct syntax for Smartsheet.

I'd prefer to do it without helper columns as I am evaluating multiple items. Is there something that will work?

Find more posts tagged with

Non-profit

Formulas

Accepted answers

KarinR

@Ldonoghue

Is this what you are looking for?

In "Good" column: =IF(Kind@row > 4, "Kind ", "") + IF(Helpful@row > 3, "Helpful", "")
In OK column: =IF(Polite@row > 3, "Polite", "")
In Needs Work column: =IF(Cheerful@row > 4, "Cheerful ", "") + IF(Attentive@row > 3, "Attentive", "")

All comments

KarinR

@Ldonoghue

Is this what you are looking for?

Ldonoghue

Hi Karin and thanks for responding! I tried that earlier, but it ends up only listing the first item in each list - so for "Good", it only listed Kind, not Kind & Helpful.

KarinR

It works when I test it if there is a 4 or 5 in the Helpful column.
Are you using a "+" sign between the two If statements?
Did you copy what I posted?

Perhaps your sheet is setup slightly differently than the screenshot?

Ldonoghue

Hi again Karin - it was a typo on my end; fixed & working. Many, many thanks!

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.