How does smartsheet sort if rows are locked?
I want to set up some parent rows on a template to group tasks together. I can't leave this totally open to users because I have an HOURS column against tasks and I want the parent row to roll these hours up. So, I've locked them to prevent users deleting the roll-up formula for this and some other summaries.
How is sort going to work? I can't test this right now, because I am an admin/owner and seem to be able to do what I want, whenever.
Desired behaviour is that the child rows will sort within the grouping of the parent, typically by start date. The grouping rows also contain roll-up dates and if these grouping rows could organise themselves by start date too, that would be good.
This would mean the parent rows are ordered by, in this case, the minimum start date of any task within the parent.