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 139
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