Hi all,
Appreciate this is probably a basic question and I'm missing something.
I've been working on the Prep a Shoe List challenge (link below) and I tried to use a formula to populate a new Comments column based on the number of colours across 3 columns. For some reason, I always get the same result "3 Colours" when I use the below formula, even where only 1 column is populated and I'd expect the result to be 1 Colour.
Challenge #289: Prep a Shoe List - Alteryx Community
IF NOT IsNull([Colour3]) THEN "3 Colours"
ELSEIF NOT IsNull([Colour2]) THEN "2 Colours"
ELSE "1 Colour"
ENDIF
Thanks
Neil
