Display the Count of items matched in a 'Relation' list

Is there a way to get the number of items matched via a Relation (list) to display in a Text component?

(We can already see the items matched in the Data sheet, so I figured the info is there just need to get to it or make it available)?

My use case: I want to display the number of reviews received for a particular item (trying to avoid using formulas in the sheet as much as possible as it is far too laggy)

Very soon.


This is live now, try it!


Nice one! :slight_smile: - exactly what I needed in order to show the number of reviews received for a particular Program



How it is done, please tell me.

Create a Rollup column against the relation column.


1 Like

I want to count number of true or false status in switch columns and number of blank row in that column.
Tried several option with roll up, it gives total count of true and false without considering blank row. My requirement is to know how many true and how many blank row.
Please Help.

Can you show a screenshot of what you are trying to do? I think you can do this if you create another If Then column that looks at the switch as well as blank and sets the result to True. Then you can do the rollup against the new If Then column. I’m not sure though if I understand what you want. What do you mean by a blank row? Is it completely blank, or just only some columns are empty? Do you want a count of True, False, and Blank or do you want a count of just True and Blank?

1 Like

@Jeff_Hager Earlier it was not working tried all your mentioned way and then applied formula in sheet to achieve that. Today once again tried after your msg and worked absolutely fine. Now deleted additional formula from spreadsheet. Surprisingly seeing no blank data in switch columns, it is either true or false. Thank you for your suggestion.
Can you please tell me how to make switch data true by default, it is to be used facility management complain tracker, whenever user log a complain by default it should be true and when issue is closed user will have option to switch off, so that it will be recorded as complaint resolved. Presently all check box is by default false.

Here is a response I posted in a different thread:

In whatever sheet contains the form button, create a template column and fill the value with ‘true’. In the form, pass that value as a Column value directly to the sheet into your switch column. Later when viewing the complaint, display the switch column as a switch that can then be turned off.

Personally it makes more sense to me to keep the value as false and the set it to true once it’s resolved, but that is only my opinion. I’m sure you have your reasons for making it default to True.

1 Like