Automatically move a sheet within a sheet?

Angelo Hijada

Hi.

So I have created a production sheet that displays all my projects and where they're at in its state (Phase 1 through Phase 5). For example:

Phase 1 Projects:

Project 1

Project 2

Phase 2 Projects

Project 3

Project 4

三期项目

Project 5

Each "project" is a hyperlink. When clicked on, it sends the user to the corresponding project's smartsheet with its own set of tasks to complete.

My question is, is there a way to automatically move these projects down phases if I complete certain tasks from the project's own smartsheet?

Thanks!

Andrée Starå

Hi@Angelo Hijada

Not sure I follow!

你喜欢工作吗?复选框,印度的ates the phase?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Angelo Hijada

Hi @Angelo Hijada<\/a> <\/p>

Not sure I follow!<\/p>

How would you like it to work? Checkbox that indicates the phase?<\/p>

I hope that helps!<\/p>

Be safe and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by <\/em>marking it as the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Angelo Hijada\",\"userID\":125753}}},{\"insert\":\" \\nNot sure I follow!\\nHow would you like it to work? Checkbox that indicates the phase?\\nI hope that helps!\\nBe safe and have a fantastic weekend!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please help the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it as the accepted answer\\\/helpful\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2020-09-04T07:10:36+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-28T00:39:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/261914#Comment_261914","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/261914#Comment_261914

No, sorry. Not what I was looking for. Just a clarification, Project 1 is a hyperlink to its own smartsheet where its own tasks. If certain tasks are completed, Project 1 from the overview smartsheet, should move down phases, depending on the tasks completed from within the project's smartsheet.

David Joyeuse

Hi@Angelo Hijada

Do you return any values from the project besides the hyperlink on the sheet where you want to move link a rank of phases or a % complete column that could be used to sort the rows?

Also, having screenshots of what you're trying to accomplish, removing sensitive/confidential data on them, could really help grasping what you want to do here.

Angelo Hijada

I hope this screenshot will suffice. For instance, Project 1 was completed and I want it to automatically be moved down to phase 2 below... also hoping Project 2 would be bumped up and not have a blank row above it haha

Angelo Hijada

Also, I wanted to add when Project 1 is moved to Phase 2, only the 'task name' column should be moved, not the entire row (the assigned person, task category, status, completion % will all be different, return incomplete/not started, and show 0% completion, etc)

Stefan

Hi@Angelo Hijada,

hmm, I see no way to have the project row automatically move within the sheet. But you may consider using a report to show your projects sorted by phase.

As source you can use your existing sheet. The tricky part will be to get the sorting the way you want it. Think about the grey rows with "phase1" etc. and how they can always appear as first entry of the phase. An additional helper column could be useful.

Hope this helps

Stefan

Andrée Starå

@Angelo Hijada

Ok.

It might be possible with a 3rd party service/integration or the Smartsheet API.

Is that an option?

Another option could be to use a VLOOKUP or INDEX/MATCH combination, but then we can't include the sheet's link.

Make sense?

Would that work/help?