Conditional format row based on whether a related table record is complete

AppSheet AppSheet Q&A
1

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

2

COUNT(SELECT( [related][key] , [status]=‘complete’ )) = COUNT([related])

Or possibly:

ISBLANK(SELECT( [related][key] , [status]<>‘complete’ ))

2 Likes
3

Count worked a treat thank you very much