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

Options
IFCC
IFCC
edited 12/09/19 in Archived 2017 Posts

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

thanks---------Mike

Comments

  • Shaine Greenwood
    Options

    Hi Mike,

    There currently isn't a way to have cell links autofill in sheets. When you have a moment, submit a Product Enhancement Request using the form under Quick links on the right of the community site.

    You might also see if third party integrations (such as Azuqua and Zapier) can automate this for you. Otherwise, if you have development resources available, you may be able to build something with our API: https://smartsheet-platform.github.io/api-docs/

This discussion has been closed.