What would be an efficient valid if expression for,
If there's already a record that has; DATE=TODAY() and the same Customer_id, cannot create a this record
๐
Solved! Go to Solution.
Please try below. I have highlighted the slight ( but important )change.
ISBLANK(
FILTER(
"Aไฟฎ็ไพ้ ผ",
([ๅไปๆฅ้กงๅฎข]=CONCATENATE(TODAY() & " (" & [_THISROW].[id_M้กงๅฎข].[ๆฐๅ]ใ& ")") )
)
- LIST([_THISROW])
)
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |