So lets say I have 3 columns.
Colums 1 and 2 have output and in column 3 I want to check if both column 1 and 2 are empty.
For column 3 I now have:
=If (IsNull([IFU_BO])) Then “No Matches” Else “Ok”
But now I want also implement the 2nd column check.
I was thinking about:
=If (IsNull([IFU_BO]) AND IsNull(“IFU_Ex”) Then “No Matches” Else “Ok”
But this is not working and giving me the datasync error.
Also tried other variants but all with the same result.
What would be the correct way to check if 2 columns are blank?