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.
Lock source links
I've created a web form that feeds a very simple tracking sheet. Each week, the person providing the info will submit their data via web form and the information flows to row one of the tracking document.
In a separate sheet, I've created a dashboard that should, in theory, pull the latest data and compare it against monthly goals.
What I cannot figure out - if it's even possible - is how to lock the cell links so my dashboard is always looking at the data in row one. Right now, it's linked to row one but next week, when the new form comes in, this week will become row two and the links follow.
Is it possible to lock this down?