Question about cell linking and automation

Nick Sor

Hello,

I have recently been put in charge of several sheets that were managed by someone no longer on our team. I have experiencing an issue with one of the sheets adding in data and I am not sure where it is coming from.

The way the sheet that I am having issues with works is that it pull in a Transaction Number and then fills the rest of the row with several cell links from another sheet, but I am not sure the Transaction Number or the cell links are being pulled in.

The bottom 8 rows in the screenshot below keep on appearing on the sheet even after deleting them or moving them to another sheet. I am unable to find an automation in any other sheet that would be moving or copying them there. For the row with "CD-test-274" it only existed in an input sheet and tracking sheet, that have now been deleted, before it started being added to this current sheet.

Andrée Starå

@Nick Sor

Happy to help!

Can you check the Apps & Integrations section and let me know what you have there?

Also, do you know if you're using any Premium Apps or other integrations?

Andrée Starå

Hi @Nick Sor

I hope you're well and safe!

Have you looked in the Activity Log or Cell History for clues?

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!

Nick Sor

Hi Andrée,

I have checked the activity log and it is showing the changes are being made by an API - Integrated App. Is there a way to find the origin of this?

Thank you

Andrée Starå

@Nick Sor

Happy to help!

Can you check the Apps & Integrations section and let me know what you have there?

Also, do you know if you're using any Premium Apps or other integrations?

Nick Sor

@Andrée Starå Thanks for the help.

I believe it may be populating due to a data mesh owned by another individual on the team. I am not too familiar with data mesh does it have the capability to create new rows in the target sheet it is linked up with?