Field "position" in view to stay the same
I'm a new Smartsheet partner trying to develop a custom solution for a client.
So the client requests Dashboard with up to date leaderboard on it. I've made the leaderboard and connected it to other data so it calculates victories, losses, goal diff and everything, and as far as i understand, best way to sort the data is through view.
And views can be then added to Dashboards.
Problem is, when i sort the view by for example, points, the position also changes. So if a team is first, it may have different number in "position" (In the screenshot its primary column). And since it has to be a view to be on a dashboard I cannot think of a solution except doing it graphically on dashboard which doesn't really look good.
This is the screenshot:
Can you please help me out? Maybe some function instead of sorting?
Help Article Resources
Check out the Formula Handbook template!