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

Ebenezer

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.

Andrée Starå

https://community.smartsheet.com/discussion/139288/how-to-show-serial-numbers-per-user-in-dynamic-view-e-g-1-2-3-for-their-assigned-rows

Hi,

I hope you're well and safe!

Can you elaborate and share a dummy sketch or something similar about how you'd like it to work?

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!