Challenge #289: Prep a Shoe List

[NMorgan]

Quick question why does the below formula not work? For every row the Comment reads "3 Colors" even for the rows which contain only 1 or 2 colours?

IF NOT IsNull([Colour3]) THEN "3 Colours"
ELSEIF NOT IsNull([Colour2]) THEN "2 Colours"
ELSE "1 Colour"
ENDIF

[NMorgan]

My solution

[Christina_H]

Solution attached

[L_indahouse]

done

[logdog0411]

Spoiler

Fun challenge, although there's an error in the official output - several double color instances are included. 

The data cleansing and unique tools solve for this problem. 

[Abdelaziz]

solution attached. 

[zacky546]

Spoiler

[OzlemSigbeku]

Spoiler

[trepryor]

 

[trepryor]

IF !IsNull([colors3]) THEN "3 Colours"
ELSEIF !IsNull([colors2]) THEN "2 Colours"
ELSE "1 Colour"
ENDIF

^ I think that the issue with your original formula was the use of NOT functions instead of exclamation points. I copied your formula, and replaced the "NOT"s with "!". This fix worked with my workflow. Hope this helps!