Linking Specific Rows Within a Column

Mitchell Ternay

I'm trying to build a cost analysis sheet based on our project pipeline sheet.  My goal is to have each individual's projects and the names of these projects to populate on a sheet so I can fill out the rest of the information.  I need to pull specific cells, yes, but automatically.  This process is moot if I have to link every cell every time.  Why I can't link the cells is that I only require specific people per cost analysis sheet and I only need their project names.  If a new project is created, I have to go back and link the cell.  I would like that to happen automatically and could if I could take a report format and simply add independent data.  Can I do this, and if so how?

Shaine Greenwood

Hi Mitchell,

 

You might consider creating a report that grabs the data you need. Details on reporting in Smartsheet can be found in our Help Center: https://help.smartsheet.com/articles/522214-creating-reports

 

Otherwise, there isn't a way to conditionally have Smartsheet create a cell link for you, but if you have development resources available to you, I'd recommend checking out our API: https://smartsheet-platform.github.io/api-docs/