Most of my Ifs are of the form If(IsBlank(varFoo), varBar, varFoo). Is there a quicker way to write this?
Derp. I had it backwards. Fixed my answer. In any case, Coalesce().
I don't mean what you've suggested. What you've suggested returns Blank() if varFoo is Blank().
That would be Coalesce(varFoo,varBar).
Notably, in behavior properties, I have found that this unfortunately does not short circuit, i.e. both arguments will always get evaluated.
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional