Trace Data Moved by Automation

Is there a way to see where data is coming from if it is input or copied into a sheet by an automation?

I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I have realized that is not the case.

The two lines are blank, except for one piece of information, the branch number. Unfortunately, this is not a very unique thing, I have over 100 sheets with a column called "Branch #".

I am sure I created an automation that is adding these two lines every night, but without opening every sheet and looking for an automation, I am not sure how to figure out where this automation is so I can delete it, or fix it…

Any advice is much appreciated!

Find more posts tagged with

Automations

Accepted answers

Paul Newcome

I have had to work with Support when I have had this issue, and they were able to locate where it was coming from.

All comments

Andrée Starå

https://community.smartsheet.com/discussion/145693/trace-data-moved-by-automation

Hi,

I hope you're well and safe!

Have you tried searching for it and looking for the last modified (might not work, but worth a try)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏

Paul Perger

Searching returns thousands of hits, as there are hundreds of sheets with the column name "Branch #" and branch "001" and branch "131" are two of our larger branches so there are literally tens of thousands of places where those pieces of data exist… The only thing I know from "Cell History" is that it takes place at 10 PM every night. Which reduces the number of automations I am looking for to be only those run at 10 PM, but without a way to search automations by when they run, I am at a loss.

Paul Newcome

I have had to work with Support when I have had this issue, and they were able to locate where it was coming from.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.