Updating Info on the Projects Index Sheet

Hi all,

Consider that I have an index sheet that lists all the projects (active or not), with the current task, it's description, timescale, owner of the task, and also the task that will come next.

Parallel to that, I have individual sheets for each project that list all the information above, and also all the remaining tasks to complete the project.

Is there a way for, as the tasks on the index are tagged as "Completed", it will update the current and next task on that same sheet?

Find more posts tagged with

Sheets

Healthcare

Project Management

Cell linking

Comments

J. Craig Williams

If I understand correctly:

The index sheet shows the current and next task for a specific project by name or description (two columns) based on activity in the specific project's schedule sheet.

When changes are made to the schedule, the index sheet is updated.

If so, then yes.

You'll need some way to determine what is current and next, which I would assume you already have or have in mind.

Here's one I wrote when the schedule is sequential (not date driven):

http://ronin-global.com/2018/07/18/finding-next-task-in-smartsheet/

and I have another one (not posted yet), that will find the next one by date.

After those are find, simply cell link or even X-Sheet reference to get the information from the project sheet to the index sheet.

Craig

Jose da Silva

Hi,

thanks for your help. I struggled a little bit with the explanation on your link (maybe because it was simply not taylor-made for the sheets I built). But I manage to achieve it through the VLOOKUP function. It works perfectly.

Thanks for your help!!

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct
Report not showing all rows
I have a report that's sorted ascending by name but stops in the "T" section. When I sort it descending by name it shows the missing names after the "T" section at the top but then stops in the "A" section, but not all of them. There are 2217 rows and 19 columns in the report right now, is there a limit to how many rows I…