How do I set up multiple case statement for required field?

Justice_RUCD

I'm trying to create a case statement to replace an empty field with the word 'incomplete' when the field in the previous 'required' column has a 'yes' response. When it has a 'no' response, it should be left blank. Here is a snip of the dataset.

This is what I've got so far, but I realize the 'if null' statement doesn't work this way.

CASE
WHEN
Oct '23 Required= 'yes'
AND
IFNULL(Oct '23)
THEN 'incomplete'
ELSE Oct '23
END

ColemenWilson

CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END

ColemenWilson

CASE WHEN `Oct ‘23 Required` = ‘yes’ AND `OCT ‘23` IS NULL THEN ‘Incomplete’ ELSE `Oct ‘23` END

Justice_RUCD

That worked! DOMO doesn't recognize 'is null' as a function so I didn't think I could use it. Thanks for your help. 😃