Conditional formula query

[NMorgan]

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

[RSreeSurya · Accepted solution]

Hi,

Using empty instead of null should give expected results.

[NMorgan]

That's great, thanks very much :)