I am trying to use the filter formula to exclude accounts starting with "Model..." within the Operator Name; see screenshot 1 below:
I tried using the below formula (see screenshot 2) but it didn't work. Any help would be appreciated.
Solved! Go to Solution.
Just use "MODEL", you don't need the .*
or
left([operator name ],5) = "MODEL"
cheers,
mark
@MarqueeCrew this worked, thank you!