Column Linking - not picking up new rows
Hi
I’m having trouble linking a ‘RowID’ column (Auto number) in my master ‘Project Intake’ sheet to a target or secondary ‘Sponsor’ sheet column named ‘Sponsor Row ID’. I use the two Row ID columns to successfully pull data using INDEX/MATCH which all works flawlessly.
I use a form to enter new projects (new row) onto the Project Intake sheet. The form does what it should do and adds a new row below the last existing row. The auto number function in the RowID column also self populates correctly.
However the linked Sponsor Row ID of the Sponsor sheet does not automatically pick up the new row in the Project Intake sheet. Try as I may I cannot link to blank rows (as I guess they don’t exist yet?) below the last row of the Project Intake sheet.
How can I overcome this restriction. It’s causing me grief as my automated workflows and summary reports all fail to pick up the new project data.
Thanks Colin
Answers
-
Hi @Buster
I hope you're well and safe!
On your Sponsor sheet, you need to manually add the Sponsor Row ID for as many rows as you need, and then it will continue to populate.
Did 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 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.
-
Yes that worked well. I had overdone the complexity with trying to import the Project ID. As the ID is auto generated in the master sheet there is no need to import it as you recognised.
Thanks Andre
-
Excellent!
You're more than welcome!
✅Remember! 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives