Bundling a list/bundle
Hello,
I use SS at my org to track onboarding of new hires. Each new hire depending on the role has specific access and training classes. Right now we select the items from a drop down, is there a way we can build bundles? So that we do not need select items one at a time.
Answers
-
Are you able to provide some screenshots for context?
-
Hi @Gigi_Ris
I hope you're well and safe!
How many different bundlings could you have?
Also, I agree with Paul. Screenshots would be great.
Be safe, and have a fantastic weekend!
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.
-
So basically based on a department and title we would select the classes on the right by using a dropdown list. Selecting one by one is a little time consuming, so wasn't too sure if we could have it auto populate a bundle of classes.
-
@Gigi_Ris It may be possible. Do you have something somewhere else (or the ability to build something in) that would allow you to input which "bundle" you want? If so, you can create a table (on a separate sheet) that has the indicators listed in one column and the selections listed in another then use an INDEX/MATCH with cross sheet formulas to pull in the appropriate selection.
=IFERROR(INDEX({Table Column w/Selections For Bundle}, MATCH([Indicator Column]@row, {Table Column w/Indicators}, 0)), "")
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives