add the current row to the count in the google sheet

[pangalawang]

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 that this TM exists should be two times.

This expression doesn't do that:

Count(Select(Timesheet[TM Number],And([TM Number]=[_thisrow].[TM Number],[Date]=[_Thisrow].[Date],[Shift]=[_thisrow].[Shift])))

0 Likes