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.
New sheet based on filter?
I created a filter which only shows the launch dates. I'm trying to export these dates to iCal but whenever I do the filter is not applied within iCal and it includes every subtask. I figure a work around would be to make a new sheet with only the filtered launch dates and export that to iCal, however I can't figure out how to do this. With the filters applied I choose "save as new" but it still includes all the original data. Am I missing something?
Thanks!
Comments
-
Hi Kroll,
Currently, filters only hide information from your sheet. When you publish to iCal or Save as New, all of the sheet data will be included. There currently isn't a way to only publish or perform a save as new of the filtered view of a sheet.
To accomplish what you need, you'll need to copy the desired rows to another sheet. The best way to do this is to Save as New, delete rows from the copy, apply your filter to the original, then copy those rows to the sheet copy you made.
This is outlined below:
- Open your sheet and Save as New.
- Open the COPY of your sheet that was made and delete all data from the COPY.
- Return to the original sheet and apply your filter.
- Select all of the visible rows, right-click on a selected row, and click Copy to Another Sheet.
- Select the COPY of the sheet you made as the destination.
You can then publish the COPY to iCal and get the desired rows.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives