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)
Where do you want to have that? Because list views can have groups where you can add a counter
I want to replace Col B spreadsheet formula with appsheet formula in the below table
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
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |