If column 1, 2, 3 are !null then Text else ""

[wonka1234]

Hi,

I am having trouble with my formula:

If !IsNull([Test One] Or [Test Two] Or [Test Three]) then "Field is Blank" Else "" Endif

results:

How come my comment is always showing? shouldnt it be blank for  row 5?

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

Try this formula: If !IsNull([Test One]) Or !IsNull([Test Two]) Or !IsNull([Test Three]) then "Field is Blank" Else "" Endif