Is it possible to identify which column is blank in a formula IF "THEN" message?

[wonka1234]

Hi,

I have a formula like so :

If (IsNull([Date)]) AND !IsNull([Status]))
OR (!IsNull([Date)]) AND IsNull([Status]))
then "ERROR, Only one of these two columns have a value."
else Null()
Endif

Instead of having a then message saying "ERROR" can I identify which column is causing the error. Ie  Something like: Column for XX is blank while Column for XX has a value.

Any advice here

[gabrielvilella · Accepted solution]

Maybe this?

IF (IsNull([Date)]) AND !IsNull([Status]))
THEN "Date null"
ELSEIF !IsNull([Date)] AND IsNull([Status])
THEN "Status null"
ELSE Null()
ENDIF

[PanPP]

Hi @wonka1234 

Another option you have when a column is not null and is empty is to utilize the IsEmpty([Date]) formula which looks for the blank value and can replace that with any value, etc.

You can utilize the IsNull option if the columns are null.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.