How about "Not IsEmpty ( field1 & field2 & field3 & field4 )"? Would that do what you want. I don't know that it is any faster, but there are less characters in it.
Any one of them can be empty and still be true.
You have an OR ( if any are not empty ). Sorry Taylor. Good try!
-- sent from my iPhone4 --
Ooooos, my bad. Good point Beverly.
Is the data all single values ( i.e. no carriage returns)? If so, how about...
ValueCount ( List ( field1 ; field2 ; field3 ; field4 ; field5 ) ) ≠ 5
**Sorry, I'm not sure if I'm misreading the question now...you've got 3 not IsEmpty() and 2 IsEmpty()?
Your answer seems "good enough" though you could clarify the calc with a Let() statement, make it more understandable to other developers (including future you).
Message was edited by: DavidJondreau
values are dates so I don't think that will work.
Gues I'll just stay with what I have cause it does work.
Always looking for a better way