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
Solved! Go to Solution.
Maybe this?
IF (IsNull([Date)]) AND !IsNull([Status]))
THEN "Date null"
ELSEIF !IsNull([Date)] AND IsNull([Status])
THEN "Status null"
ELSE Null()
ENDIF
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.