Dynamically reference fields in formula tool

[jt98]

Hi, I've been searching for some time in discussion but still dont seem to get a solution.

I have a formula to that shows that if any of the columns A to E is not null, not Indicator = True,
else, False

Formula:

IF !IsNull([A]) OR
!IsNull([B]) OR
!IsNull([C]) OR
!IsNull([D]) OR

!IsNull([E])

THEN 1
ELSE 0
ENDIF

ID	Start Date	End Date	A	B	C	D	E
159	1/1/2020	6/30/2020		X
230	1/1/2020	6/30/2020		X
294	1/1/2020	4/3/2020	X
294	4/4/2020	12/31/2020	X
313	1/1/2020	6/30/2020		X

However, Column A may or may not appear in the input data that is running into the formula and the workflow then prompts an error that Column A cannot be found. 

Is there a way to dynamically reference column A when its present in the data and ignore it when its not so that it doesnt produce an error?

Thank you!

[AkimasaKajitani]

Hi @jt98 

If you want check null dynamically, you would better to change having the data vertically.

[messi007]

@jt98,

Please see below:

Hope that helps!

Attached the workflow,

Regards,