Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Link to static cell in dynamic sheet?
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.