Mar 19 2021 02:59 AM
Hey there I have multiple Tables in one sheed and I want to run through them all to find out if specific culums are empty.
I tried the following:
{=IF((ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[Title_1]"))+ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[TITLE_2]")))<>0;"Option if true";"Option if false")}
But it isn't working it always jumps into the Option for false even if it should be the option for true.
I already tested:
{(ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[Title_1]"))+ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[TITLE_2]")))<>0}
and it works.
Is there a way for me to make the IF - function work? Thanks for the help :).
Mar 19 2021 06:19 AM
Mar 19 2021 09:44 AM
Mar 19 2021 11:06 AM