Good afternoon Smartsheeters ;)
I am only new to Smartsheet and have started working on some existing docs.
We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row. Then Rows are deleted or new rows added so depending on where it sits from a PRIORITY perspective, we might add it 2 and therefore create 2.1, 2.2 etc as we DONT want to renumber all the others rows.
Once a Row is given a priority number (which is determined externally and then applied to that row/item) then that row/item must keep that number for that project.
This process limits our ability to use 'sort' and a few other functions. I have had a look at peoples suggestions re WBS coding (parent/child) but that doesnt seem to work for what we need.
Also - we are not currently using Parent/Child relationships because of the issues with our need to run a Priority number. Open to ideas on how to change things so as to get the best out of Smartsheet and ease of use