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.

Auto linking cells once populated by a web form

Chris Fox 25
Chris Fox 25 ✭
edited 12/09/19 in Archived 2016 Posts

Hi!

 

I am trying to use a Web Form to populate a "Master List" full of 30 columns of information. I would like the info located on that "Master List" to trickle down into 3 different "Sub Sheets" that present only selected info from the "Master List". However I am having trouble getting blank cells to understand that once they have been populated they should link to the specific sub sheets. Is there any solution here?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Bobby Andres
    Bobby Andres ✭

    new blank cells cannot be cell linked. If you added data to the cells, saved, then deleted the data, you could cell link them. That being said, web form entries will be added to the next NEW row. If you do the above, the row will not be "new" (even if it is blank).

     

    I would recommend using Zapier which can copy row data from one sheet to another when a new row is added. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories