Cell Linking Contact Lists
I have two sheets I want to link but I am having an issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both sheets so I am not sure why the information is not populating.
Please help!
Best Answer
-
Did you create a contact list in the first sheet? I have seen it to where if I create a contact list then use an item from that list linked to a cell in another sheet, it doesn't always populate correctly. Secondly, I have seen that sometimes it has been taking quite a while to populate the data in the sheet that is receiving the data. Did you hit save on your sheet that you are linking from as well?
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Answers
-
Did you create a contact list in the first sheet? I have seen it to where if I create a contact list then use an item from that list linked to a cell in another sheet, it doesn't always populate correctly. Secondly, I have seen that sometimes it has been taking quite a while to populate the data in the sheet that is receiving the data. Did you hit save on your sheet that you are linking from as well?
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Hi @MirandaLang
I hope you're well and safe!
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
Hello, thank you so much for taking the time to answer my question! I was confused because some cells were populating instantly and others were not so I was thinking it was a format issue. Thankfully, after awhile, I went back to the sheet that was pulling from the original and my cells were all populated!
Must just be a lag, thank you for the input!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!