Can you spot the error in my multi-row formula?

HelenL

Line 3 works perfectly.

Why is it not recognising "Null" in Line 1 and 2.

Media and Magazine fields are both String.

Thanks for looking

Media and Magazine 1.png

Media and Magazine 2.png

Preparation

Accepted answers

jasperlch

That is strange as it works fine on my machine. Try using IsEmpty(Media) and IsEmpty(Magazine). IsEmpty function takes cells with a space or blank string as True as well.

Thanks,

Jasper

New Workflow5.yxmd

All comments

HelenL

Thanks for your quick reply.

I tried this but got the same result.

IF ([Media] = "Media" AND IsNull([Magazine])) THEN "Media"
ELSEIF (IsNull([Media]) AND [Magazine] = "Magazine") THEN "Magazine"
ELSEIF [Media] = "Media" AND [Magazine] = "Magazine" THEN "Media & Magazine"
ELSE "test"
ENDIF

jasperlch

Hi, for recognising Null Values, you will need to put IsNull([Media]), IsNull([Magazine]). By the way, you could probably use a normal Formula tool for your current formula.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703