Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAQuick 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
done
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.
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!