Appsheet Group Counter Formula

[desmond_lee]

Is there an appsheet formula for group counter like below table example? In google sheet it's very simple, =QUERY(ARRAYFORMULA(IF(LEN($A:$A),COUNTIFS(A:A,A:A,ROW(($A:$A)),"<="&ROW($A:$A)),)),"SELECT Col1 LABEL Col1 'GROUP COUNTER'",1)

[SkrOYC]

Where do you want to have that? Because list views can have groups where you can add a counter

[desmond_lee]

I want to replace Col B spreadsheet formula with appsheet formula in the below table

[SkrOYC]

Wait, what does that has to do with the OP?

If you give further explanation I could help, but I think that this will help:
COUNT() - AppSheet Help
SELECT() - AppSheet Help
FILTER() - AppSheet Help