Can i link cells so when i fill out a form it links the new information to another sheet

Rotafieeen

Can i link cells so when i fill out a form it links the new information to another sheet (sales) the other sheet (sales) also has a form that gets filled out, would like one form to fill out its sheet(intake) but link the new information if sales is selected to the other sheet (sales)

BullandKhmer

You cant do this automatically thorough cell linking, you could however use either a copy row automation or index formula.

Andrée Starå

https://community.smartsheet.com/discussion/122506/can-i-link-cells-so-when-i-fill-out-a-form-it-links-the-new-information-to-another-sheet

Hi,

I hope you're well and safe!

You could connect the sheets using cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure. When you update the source sheet, it will reflect on the destination sheet.

To connect them row by row, you could use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID for as many rows as you need in the Destination sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!