# Count column conditional on other criteria **URL:** \ **Category:** Ask for Help\ **Created:** [December 12, 2024, 6:48am UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536 "2024-12-12T06:48:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Eddy\_Fuller](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eddy_fuller/32/82785_2.png) [@Eddy\_Fuller](https://community.glideapps.com/u/Eddy_Fuller)\ **Post date:** [December 12, 2024, 6:48am UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/1 "2024-12-12T06:48:53Z")
Hi, I cant seem to find the answer to this anywhere? I am trying to make a column that counts the occurance of each exercise per client, but increments up each time it occurs eg. the 1st occurance shows 1, the second shows 2, the third shows 3 and so on, the purpose of this is to be able to find test number 1 and compare to test number 2 or 3 etc. rather than trying to find them by specific dates as people test on different dates ive attacehd the columns im working with and also a manual column of what the output should look like when people suggest relations and rollups it just says rollups dont work on relation columns? but then i also want the incrementing value based on date? thankyou! ![Screenshot 2024-12-12 at 06.43.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4448d485beb108e237b94dc987478f8f9dbc0548.jpeg) ![Screenshot 2024-12-12 at 06.44.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c163873206ac057c3ab52b210992792515e1634.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 12, 2024, 7:29am UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/2 "2024-12-12T07:29:31Z")
- Create a Query column with appropriate filters to match similar rows - Create an array of RowIDs via the Query with a Lookup column - Use a Find Element Index column to select each RowID from the array - Use a Math column to add 1 to the index ---
**Author:** ![Eddy\_Fuller](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eddy_fuller/32/82785_2.png) [@Eddy\_Fuller](https://community.glideapps.com/u/Eddy_Fuller)\ **Post date:** [December 12, 2024, 8:18am UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/3 "2024-12-12T08:18:34Z")
This is my query column ![Screenshot 2024-12-12 at 08.17.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb91b0ce3ea5da2ac728fb3839ada16d040eac73.png) when i go to lookup through the query i get this? ![Screenshot 2024-12-12 at 08.18.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6695892a464a8dde909d3dfdf3a119dd1647277.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 12, 2024, 10:54am UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/4 "2024-12-12T10:54:58Z")
ah, it’s a Big Table. That makes a difference. Although, I would expect that Lookup to be supported but limited to 100 rows. Are you creating that in the same table? Also, do you have the below preview feature enabled? ![CleanShot 2024-12-12 at 18.54.37@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/9666b1005d2a9aacc633775981ff6a459c0efb52.png) ---
**Author:** ![Eddy\_Fuller](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eddy_fuller/32/82785_2.png) [@Eddy\_Fuller](https://community.glideapps.com/u/Eddy_Fuller)\ **Post date:** [December 12, 2024, 5:26pm UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/5 "2024-12-12T17:26:56Z")
ah i see, yes ive checked that now and it is saying 100 rows does that mean only 100 rows of the formula? or will only pull through 100? eg for each client the most weve had is like 15 entries of one exercise or if it means only 100 rows then yes we would exceed that ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 12, 2024, 6:01pm UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/6 "2024-12-12T18:01:58Z")
It should be the first 100 rows that match the query filter criteria. ---
**Author:** ![Eddy\_Fuller](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eddy_fuller/32/82785_2.png) [@Eddy\_Fuller](https://community.glideapps.com/u/Eddy_Fuller)\ **Post date:** [December 12, 2024, 6:24pm UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/7 "2024-12-12T18:24:13Z")
oh ok so that would be fine, its being used in an exercise logging database that currently has like 3000 rows in it gathered this year, with view to grow it more each year, so maybe 5000-10000 per year being entered. is this enough to warrant use of a big table? or should i use a normal one? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 12, 2024, 6:56pm UTC](https://community.glideapps.com/t/count-column-conditional-on-other-criteria/78536/8 "2024-12-12T18:56:45Z")
My general rule of thumb is if I expect 10k or more rows per year, then I will use a Big Table.