Copying rows w/ checkmarked cell to different sheet
AliKhan
✭✭
Hello,
I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns.
Sheet 1: list of skus with descriptions and details. One column has a checkmark for the critical skus
Sheet 2: auto copy (i.e. link) only specific columns for the critical skus from sheet 1. Sheet 2 will have additional columns that need to be added for these critical skus.
Any help is greatly appreciated.
Comments
-
On the second sheet, are you needing to do any manipulation of the data? i.e. create formulas for tabulation.
If not, and the second sheet is only for displaying the specified information you can use a Report to accomplish this.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives