Auto update columns across sheets
Hi,
I use a form to collect details from participants. This goes in a participants sheet (1).
The name and the country of residence (and none of the other collected information) I want to use in another sheet (2) and add some other columns of information to them. So I linked the the columns in the new sheet (2) to the sheet (1) that collects the information with the form.
I see the link indicated (little blue triangle) in the sheet (2) but when new names are added in sheet (1), the sheet (2) is not updated.
How can I make this update in sheet (2) happen?
Thank you for your help.
Victor
Best Answer
-
Hi Victor,
I assume that you’ve used cell-linking between the sheets. If that is correct, it will not work because you can’t have the cell-link update when a new form submission is added.
You’d need to use VLOOKUP or an INDEX/MATCH combination instead.
Make sense?
Would that work?
I hope that helps!
Be safe and have a fantastic weekend!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi Victor,
I assume that you’ve used cell-linking between the sheets. If that is correct, it will not work because you can’t have the cell-link update when a new form submission is added.
You’d need to use VLOOKUP or an INDEX/MATCH combination instead.
Make sense?
Would that work?
I hope that helps!
Be safe and have a fantastic weekend!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
Yes, I used cell linking.
VLOOKUP. I will give it a try even though this spreadsheet knowledge is a bit rusty.
Thank you for your help and have a good and safe weekend too!
Victor
-
You're more than welcome!
Let me know how it goes and if you have any questions!
✅Remember! 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives