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!
