Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Cell Linking Ability to Filter or Sort Source Sheet / Source Sheet does not stay filtered
All: I have looked but cannot find other questions regarding this topic. Apologize for any redundancy; and, thank you for any help on these two topics. Sandy
Ability to Filter or Sort Source Sheet:
From my (master) destination sheet, I click cell link icon. Then, I select my source sheet. Is there a way to filter or sort the source sheet by contact list so that I can group all rows by resource?
I have multiple source sheets from which I need to pull data (by resource) into my master sheet. Other columns in my sheet might be the filter/sort focus at some future point.
Perhaps I am missing the option.
Source Sheet does not stay filtered:
Thinking I could "trick" Smartsheet, I first filtered my source sheet before attempting cell linking. On opening my source sheet, I found the "filtered" sheet was no longer filtered. Being new to Smartsheet I am not sure that filters are "savable."
Comments
-
Filters save when viewing the sheet. But filtered views only affect the user who placed the filter. In your instance, I don't think filters will apply when cell-linking. You're not actually viewing the filtered sheet, its giving you everything so that you don't miss data you might need.
Have you tried sorting the source sheet? That should permanently align all your data together making it easier to grab.
-
Mike: Wow, I did not reply to your comment. Thank you for remarking. I will try as you suggest. Sandy
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives