Hi There
I'm having trouble with an expression for conditional formating. I want the row to change when all the related table records are marked as complete at the moment i am using the below but its not working and wondering if anyone has any tips on this as unsure if i should be using a select expression or similar.
AND([Customner date]<today(),[related parts 2].[Status]=1,)
Thanks
Solved! Go to Solution.
COUNT(SELECT( [related][key] , [status]='complete' )) = COUNT([related])
Or possibly:
ISBLANK(SELECT( [related][key] , [status]<>'complete' ))
COUNT(SELECT( [related][key] , [status]='complete' )) = COUNT([related])
Or possibly:
ISBLANK(SELECT( [related][key] , [status]<>'complete' ))
Count worked a treat thank you very much
User | Count |
---|---|
33 | |
30 | |
29 | |
20 | |
18 |