Link project progress with master file

EdsonCrz94
EdsonCrz94 ✭✭
edited 02/24/23 in Smartsheet Basics

Hi,

I have a doubt about cells linking, probably for many of you this will be simple but to me… it's another story.

I've created a project's master sheet in a workspace in Smartsheet which we use to manage new projects, an online form feeds this file. Each time a new project is created, we assign it a unique ID. After the project (row) passes the approval process, we (the PMO team) creates a folder with a project plan and other sheets. Between those, we have one that retrieves data from the master file using MATCH and INDEX once we type the project ID in it.

However, what I want to do is to do it in the other direction, retrieving the project %, start date, end date and if possible the dashboard link such as the project plan link.

Hope this is possible.

1.png 2.png


Answers