Indent under a lock row

Hello to all,

I have a sheet for tracking material order. At the bottom there is a completed section with many parent child relation, see attached file. T0 completed, T1 year, T2 month, T3 project, T4 list of material. The sheet automatically lock every thing that is in T3 and T4. Rows in T0, T1 and T2 stay unlock. Unfortunately, when a shared user (not admin) bring a new project to the bottom, It is set as a T0 tier and that user cannot indent the project to become a new T3 (the parent is month not the previous project). This is cause by the fact that the last row of the previous project is lock even thought there is no link at all between the 2 projects.

Do you know a way to set the sheet so the users can move the projects and indents at the right place?

Thanks for your time

Maxime

Find more posts tagged with

Project Management

Comments

Andrée Starå

Hi Maxine,

Can you share the sheet or a copy of it so I can get a better understanding of what you want to do?

A possible workaround would be to have an area to collect everything and then an admin would move them to the correct group.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Maxime Schmidt

here is the link to a copy of the page

https://app.smartsheet.com/b/home?lx=PhMABpo2rIFAO_B1XHOzWg

I should also provide a little bit more context.

We work in aeronautic. This mean I can't share customers information. I create a blank copy of the page and removed some columns that were not useful for this discussion and allow and easier access to the formulas at the end. These formulas detect if the row is under the completed section and an automatic action lock them.

Some Information about the workflow we are using.

the technicians that work on aircraft engine ask materials from a form. This entry get at the top line. Than storeman look if we can supply the parts or if it need to be ordered from the customer or a supplier and keep traceability. Our quality procedure requires us that the storeman can't change the input from the form so there is some column that are lock and storeman aren't admin. When project are done the storeman drop them in the completed section. Currently, we got hundreds of projects done so it would be combersome for an admin to pass behind the storeman and sort them all.

I hope those info help

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto