Bundling a list/bundle

Gigi_Ris

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.

Paul Newcome

Are you able to provide some screenshots for context?

Andrée Starå

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!

Gigi_Ris

@Andrée Starå @Paul Newcome

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.

Paul Newcome

@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)), "")