Sign in to join the conversation:
Is there a way to lock a row based on criteria in that row? For example, I want the row to lock if the "Tier" column is a "2" or "3." Thanks.
Hi Stephanie,
Yes, you can set it up with the help of Alerts & Actions, and you can set it to lock or unlock when the Tier changes for example.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I second Andree's response. I use this very regularly when building out more complex project plans. I will use a helper column to designate which level of hierarchy the row is in. I then set up the automatic lock/unlock rules to lock my parent rows (the unlock is to unlock the row if I change the hierarchy level).
This keeps me from having to scroll through long sheets looking for any parent rows that I may have missed locking or child rows that I may have missed unlocking.
I also double that up with conditional formatting to have a specific format set for each level of hierarchy. That helps with consistency throughout while again keeping me from having to look through thousands of lines.
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
I have shared sheets and dashboards with people outside of my organization, and one has a paid license. Would I be able to grant admin access to this licensed user to their sheet? Or would the ownership of the space by one organization limit the admin accessibility of someone from outside?
