Conditional format parent table based on child status values

AppSheet AppSheet Q&A
1

Hi There

I was hoping for some help. I’m trying to do a conditional format so that when all the related items in my child table reach a status “parts for assembly” that it changes the parent table. I’ve tired doing this with count and select function but without much luck I just wondered if anyone had any insights to this?

Thanks

2

Try:

COUNT([_thisRow].[Related Child Tables])=COUNT(SELECT(Child Table[Key Column],AND([Parent Reference Column]=[_thisRow].[Parent Key Column],[Staus]=“parts for assembly”)))

3

thank you so much that works perfectly

1 Like