Hi community, I have a question about how to add a formula for Valid If in data validity to check if that product SKU already exist (not key column), If yes, an Invalid value error will appear and not allow me to add new data. If not, so let me add a new row.
By the way, it still allows me to edit that row if necessary.
Thanks
Solved! Go to Solution.
ISBLANK(FILTER("tableName", [SKU] = [_ThisRow].[SKU]) - LIST([_ThisRow]))
ISBLANK(FILTER("tableName", [SKU] = [_ThisRow].[SKU]) - LIST([_ThisRow]))
It does not check whether does SKU already exist or not
Try Then Tell
Appreciate it, thanks, the expression after works correctly.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |