Link to static cell in dynamic sheet?

Walter Day

Hi,

 

 

I’m trying to figure out if a feature I’m looking for is available with Smartsheet. I have several Smartsheets, each with their own forms, for recording inspection results of various elements in a warehouse. Each time an entry is created in the form, a row is added to the top of the sheet with the user, date created, and the information the user put on the form. I want cells in a master sheet to keep track of the newest creation dates, and a due date next to those which will be set as a reminder to email the team if a due date is reached. I’ve included a picture of the master sheet for reference. Basically, I want the "Last Performed" column in the picture to link to the appropriate cell, which will always be in Row 1 of the corresponding sheet. any help you guys can provide would be appreciated.

 

Greg Gates

You can do this, but not automatically (at least not to my knowledge). If you right-click on the cell, you can click "Link from Cell in Other Sheet..." Then, choose the cell you from your desired sheet. This will automatically populate this cell in the master sheet with the same value. If someone ever edits/updates the date on the inspection sheet, it will automatically update the value here on the master!

 

If, instead, you were looking to pull this value by writing a formula that automatically grabs it from the sheet listed in the EHS Inspections column, I don't think that's possible. To my knowledge, Smartsheets can't access a dfferent sheet inside of a formula. I hope that helps!