Issue with Valid_if Constraint

hi in one my columns i have set to capture location…and have set a valid if expression as below

[Location]<>“0.000000, 0.000000”

but inspite of this i am getting 0.000000, 0.000000 as the result in the google sheet…

how can this be resolved

Solved Solved
0 1 138
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Try:

AND(
  ISNOTBLANK([Location]),
  ("0.000000, 0.000000" <> [Location])
)

View solution in original post

1 REPLY 1

Steve
Platinum 4
Platinum 4

Try:

AND(
  ISNOTBLANK([Location]),
  ("0.000000, 0.000000" <> [Location])
)
Top Labels in this Space