Nested If Or IsBlank + If Statement

Shelly Toy

I'm trying to write a formula for the following:

1 -If GO FW is blank then "shop closed"

2 - If GO Date is different than Original GO Date then "shop open date change"

If neither 1 or 2 then nothing

Kelly P.

@Shelly Toy

Try this:

=IF([GO FW]@row = "", "Shop Closed", IF([GO DATE]@row <> [ORIGINAL GO DATE]@row, "Shop Open Date Change", ""))

Hope that helps!

Kelly P.

@Shelly Toy

Try this:

=IF([GO FW]@row = "", "Shop Closed", IF([GO DATE]@row <> [ORIGINAL GO DATE]@row, "Shop Open Date Change", ""))

Hope that helps!