Checkboxes to Generate List

Good evening!

I need a little help to see if what I want to do is even possible. I am wanting to create a list of people based off of a response to a checkbox. For example, if someone completed a form with their name, address, and other fields to include checkboxes, and checked a box titled 6/7, I would want that person's name to show up on a list in another smartsheet form. I know I can create this with filters but all I want is just the persons name to go to another sheet. I am trying to figure out if a formula even exists for this.

I use cross sheet formulas quite a bit but can't figure this one out for some reason. Appreciate the assistance.

Find more posts tagged with

Formulas

Automations

Cell linking

Accepted answers

All comments

Bassam Khalil

Hi @Jennifer Roam

Hope you are fine if you want the name to show in the new sheet when the person complete chacking all the check box it's easy, but if you want the name to be listed on the dropdown menu of the second sheet form that will not work with you, if you can supply more details about the sequence of your operation with more screenshot maybe i can help you to do what you want in deferent approach.

Andrée Starå

Hi @Jennifer Roam

I hope you're well and safe!

You could maybe use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet it will reflect on the destination sheet.

Is there something unique that we could use to link the records?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jennifer Roam

Essentially, the person is filling out a form telling me what day they are going to be at a site. They do this by using checkboxes. Once complete it goes to the smartsheet. What I want to do is pull a "roster" so to speak on a separate sheet that lists out all the persons who said they were going to be on site that day. The roster sheet has no information on it (I am actually using the names that I want to get to use a VLookup function to pull additional information. See screen shot below. When the boxes are checked on the first sheet, I want it to pull the names from the corresponding row and place them on the second blank sheet.

Michele Rainforth

As long as you just want the names to show up on a different sheet, I would use the Copy Rows workflow.

Screen Shot 2021-02-23 at 9.02.30 AM.png

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.