Iโm hoping someone can help me with the proper formatting for this.
I am attempting to do something along the lines of OR((ISNOTBLANK[Payments],ISNOTBLANK[Driver Notes:])) but it isnโt working.
Thanks in advance
OR((ISNOTBLANK[Payments]),ISNOTBLANK[Driver Notes:]))
here after [payment ]) close bracket was missing for first isnot blankโฆ
maybe thatโs the issue
Expression โOR((ISNOTBLANK[Payments]),ISNOTBLANK[Driver Notes:]))โ could not be parsed due to exception: Number of opened and closed parentheses does not match.
OR((ISNOTBLANK[Payments]),(ISNOTBLANK[Driver Notes:]))
Unable to find table โISNOTBLANKโ
So the syntax can be confusing, but hereโs a useful primer โฆ
So in light of this, @WillA108 the error in your formula is that you are using the last of those three patterns when actually you want to use the first of them.
Try
OR(
ISNOTBLANK([Payments]),
ISNOTBLANK([Driver Notes])
)
Btw, I always try to break up a formula into multiple lines so it becomes easier for me to read later, match the parentheses, etc.
Thank you!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |