Blanks in Conditional Column

Here's what you can do:

Create a "Custom column" where custom colum formula =""

Then, reference the newly created, totally blank column in your conditional column setup and "Voila!"

Hope this helps!

Namaste.

---

Anonymous wrote:

Hi,

 

I have blanks in my column in the query and I am trying top use it in a conditional column.

 

What would the test be, it is not null as there is not a null in the column only a blank cell.

 

Thank

'null' may not work in the wizard unless the value is missing.  "blank" cells in Excel files may have the apostrophe character -- so use **** ' **** (exclude asterisks/spaces) in the wizard