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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!