my aim is if I have this one TM in the g sheet, and I input the same TM in the current row, I would like to automatically add that current row to the total count that this TM existed. simply, if this TM is already in the G sheet then the total count ...

why this expression below is giving a wrong result:IF([New Delivery]=TRUE,ANY(SELECT(DELIVERY[Check Number],[Timestamp]=MAX(Select(DELIVERY[Timestamp],[BRANCH]=[_THISROW].[GS BRANCH])))),Any(Select(Order Details[Check Number],[Timestamp]=MAX(SELECT(O...