Tracking rows from other sheets

Hi everybody

I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet.

The only approach I can think of is adding a column on each sheet with its name so when the row is moved, it is added to the master sheet.

I am not a big fan of this solution as it forces me to add yet another column. Is there a more "elegant" way to resolve my issue (ideally I would like my master sheet to detect from which sheet the row comes from and display its name)

Thanks in advance.

X..

Find more posts tagged with

Sheets

functionality

Accepted answers

Paul Newcome

As of right now, the extra column containing the sheet name is the only way to go. It would be nice though if it could automatically detect/input the source sheet name. Feel free to Submit a Product Enhancement Request when you have a chance.

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment to include that information, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Paul Newcome

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment to include that information, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

X M

I was hoping for an alternate solution I could not think of but if adding a column is the only then I will.

Paul, Andrée, thank you for your comments

Andrée Starå

@xav

Happy to help!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.