Column Linking - not picking up new rows

Buster

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

Andrée Starå

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!

Buster

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

Andrée Starå

@Buster

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!