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

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
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.