How to combine 3 columns and find possible combinations

Question

I need to create a category list in one column.

Each column / category is listed as True or False ( I have 3 categories)

Some rows could be True for all 3 categories, while some could be only one category or neither. I was wondering if I could create a combination for each. See example below, the column for "new category" is the results I am trying to get.

REDYellowGreenNew category   FalseFalseFalseNeither   TrueFalseFalseRED   TrueTrueFalseREDYELLOW   TrueTrueTrueALL

flying008 · Answer

Hi,@Jetblue

The other way to dynamic resolve with simple formula.

IF IsEmpty(ReplaceChar([New category], "-,","")) THEN 'Neither' 
ELSEIF Right([New category], 1)='-' THEN ReplaceChar([New category], "-,","") 
ELSE 'ALL' ENDIF

Luke_C · Answer

Hi @Jetblue

Here's how I would do this. I chose not to do the long if statement approach and instead tranpose the data to check for true values in each record and apply the logic from there. This would work for any number of columns.

New Workflow17.yxmd