Auto Populate Column Data

I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data.

I need the data inputted from form1 to auto populate the entire column the data resides in when form2 is submitted.

Any suggestions on how to accomplish this since I cannot apply cell formula to a column?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Yes. The "@row" piece of the formula is looking for the cell within the row of the formula. So on any row where the meta columns are blank, "@row" will also return blank.


    Try this instead:

    =INDEX([AT-Meta]:[AT-Meta], 1)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers