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.
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows.
My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar for just shipping data.
My inquiry is if there is a way to automate this at all? So I don't have to make new links for each new row.
On "Shipdate" sheet. Row1 = Row17 on Master, Row2 = Row34 on Master, etc etc