How to Show Serial Numbers Per User in Dynamic View (e.g., 1, 2, 3 for Their Assigned Rows)?

Ebenezer
Ebenezer ✭
edited 05/14/25 in Add Ons and Integrations

Hi Smartsheet Community

I'm working on a project where I’m using Smartsheet Dynamic View to let users see only the rows assigned to them. My setup uses:

In the Dynamic View, I want each user to see a Serial Number (S.No) column that starts from 1 and counts upward based only on their visible records.

Example:

Let's say the user Pranesh has:

  • 5 records in Sheet A
  • 10 records in Sheet B
  • 4 records in Sheet C

All 19 records appear in his Dynamic View. I want the Serial Number column to show values from 1 to 19, in that view β€” regardless of the original row number or sheet source.

Answers