Hi There. I am trying to create a show if expression for a column with an address. The address column should only show in the form if the location is not picked up automatically in the location column. I have used this [Location]=0.000000, 0.000000 but it is not working. This is what shows in the location column when location has not been picked up. What am I doing wrong?
Personally, I haven’t dealt with a situation exactly like yours so I’m not sure but I wonder if ISBLANK([Location]) might not work.
Thanks Kirk, I tried that already. Didn’t work.
I see. Sorry I couldn’t help. Good luck!
Try:
([Location]="0.000000, 0.000000")
Thank you Steve, I got it to work.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |