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 |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |