Capture data from column 1 first row to column 2 second row with formula

Happy

Hi All,

I am creating a CICO using smartsheet. since the data for CI and CO is key in separately in different row. Is there anyway I can use formula to capture the data by comparing the Unique ID and date?

Paul Newcome

I would suggest a second sheet. The first one has the Form 1 submission and all columns for both. The second sheet would have Form 2 attached to it.

Then in the first one you can use an INDEX/COLLECT to pull Form 2 submissions over.

=IFERROR(INDEX(COLLECT({Column To Pull Over}, {Unique ID}, @cell = [Unique ID]@row, {Date}, @cell = [Date Column]@row), 1), "")

Happy

Hi @Paul Newcome ,

Thank you for the advice, let me try it out.