IF formula on a Status field

[data_quantum (John)]

I want to check a status column (using the default ‘status’ field) for empty values and return a value in another column based on the empty status:

IF({Status}="","COMPLETE","INCOMPLETE")

When the ‘Status’ column is unselected (i.e., its grey (by default), and has no value associated with grey), the new column shows “INCOMPLETE”, but it should show “COMPLETE”.

Could this be that the grey label in a Status field has a value associated with it, even tho there is no value given to it?

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi John,

Try:`

IF({Status}="Empty","COMPLETE","INCOMPLETE")

---

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

[Jguido (Joe Guido)]

@data_quantum Try naming the empty status. That’s what i do and it works fine. I attached an example.

[data_quantum (John)]

Awesome! This did the trick, thanks @GCavin

@Jguido that also looks like a workable solution, although I haven’t tried it yet, thanks for replying!