Get count of only visible table rows

1

Hi people,

I have a canvas formula where I am trying to calculate the count of only visible rows of a table.

So as I filter the table using the filter bar, search box or regular filters, this count should change.

How can I do this?

Thanks!

2

Hey @Jeremy_G - References to a source table in a formula will always provide all rows even if there’s a filter on the source table. But references to a view will only return the visible rows. So…

  1. Create a view of the table in question
  2. Filter that view
  3. Change your formula to use the view

That should do it!

2 Likes