Forum Discussion
Anonymous
8 years agoNot applicable
Blanks in Conditional Column
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. ...
- 8 years ago
Anonymous,
You may use code below.
if Text.Trim([Column1]) = "" then
Spk495
7 years agoNew Member
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