Cell Linking from multiple sheets

Deborah Tzuberi

Hello,

I am in the process of creating a main spreadsheet that will house information from other spreadsheets, that will house information submitted via forms. I'm having trouble linking data (when pulling from one spreadsheet into the main sheet. I know how to link cells, but if I create links in the main sheet prior to information being submitted via forms, the form data is entered on rows below where the cells are linked (on their respective sheets). This essentially stops data from being linked to the main sheet, since the rows where the form data is entered ends up not being linked. I'm sure it's user error - i just can't find what my error is. Any help will be appreciated!

Andrée Starå

Hi @Deborah Tzuberi

Cell-linking doesn't work with rows that aren't created yet. You'd need to use cross-sheet formulas instead.

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 post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Deborah Tzuberi

I watched something that noted if you have at least 2-3 rows above and/or below data, then Smartsheet will notice a pattern and automatically use the formula in the new row. Would this apply to cell linking as well?

Andrée Starå

@Deborah Tzuberi

No, unfortunately, it doesn't work for cell-links.