Populate a sheet based on checkbox from separate sheet
I have a sheet that keeps track of required development for a project (we will call it Testing). I want to create a checkbox on that sheet called "Documentation Required". If Documentation Required is checked I want to take several rows from the Testing Smartsheet and populate those rows into a new/separate sheet, we will call that one Request. Is this possible?
Best Answers
-
Yeah you can do this. probably easiest way is to use a copy row automation, so when the box is checked the row is copied to another sheet. In the new sheet, reformat. Hide any unwanted columns add any additional columns that you want in the new sheet.
- Set up check box
- Copy sheet and in the new sheet reformat, hid unwanted columns remove unwanted formula, add new columns if wanted etc... note you cant delete a column that is in the source sheet, you can but it will just come back next time the automation runs.
- In Automations select When the sheet changes and box x is ticked copy row, selecting the new sheet.
That'll do.
-
@JTodd if you are trying to copy only certain information and not every column, you will want to use Zapier to do this. If you use the native Smartsheet functionality it will copy all of the columns from the initial sheet over to the recipient sheet. You can hide columns on the receiving sheet, but it makes the sheet "bloated".
Answers
-
Yeah you can do this. probably easiest way is to use a copy row automation, so when the box is checked the row is copied to another sheet. In the new sheet, reformat. Hide any unwanted columns add any additional columns that you want in the new sheet.
- Set up check box
- Copy sheet and in the new sheet reformat, hid unwanted columns remove unwanted formula, add new columns if wanted etc... note you cant delete a column that is in the source sheet, you can but it will just come back next time the automation runs.
- In Automations select When the sheet changes and box x is ticked copy row, selecting the new sheet.
That'll do.
-
Hi @JTodd
I hope you're well and safe!
Unfortunately, natively, it's not possible, but it's an excellent idea!
Here's a possible workaround or workarounds
Would it always be the same rows that you'd like to include in the new sheet?
- Smartsheet API
- 3rd-party service like Zapier or similar
Would any of those options work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@JTodd if you are trying to copy only certain information and not every column, you will want to use Zapier to do this. If you use the native Smartsheet functionality it will copy all of the columns from the initial sheet over to the recipient sheet. You can hide columns on the receiving sheet, but it makes the sheet "bloated".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 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
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!