I have a “valid if” condition whether a customer number exists. It works for a new entry but not when I edit the row. What can i do?
NOT(IN([KdNr] , kunden[KdNr]))
Solved! Go to Solution.
NOT(
IN(
[KdNr],
SELECT(
kunden[KdNr],
([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER])
)
)
)
NOT(
IN(
[KdNr],
SELECT(
kunden[KdNr],
([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER])
)
)
)
Thanks a lot!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |