How to link a checkbox from a checklist to a column in a Report?

LCarter

Capture 2.JPG

Capture.JPG

I was wondering if someone could please help with linking!

I have attached two photos for a reference. One is of the checklist (which is the one with the rows) and one is the report (which has all the tick boxes in the columns).

I am wanting to make it so when the payroll box is ticked on the checklist , that is pulls through to the column on the report.

Thanks

Lichelle

Sandra Guzman

Hi @LCarter,

You need to create a filter on your report to pull through the checklist when it is marked.

When you create your report, you will pull through the sheet and select the columns to display. Then you want to select the column title from the dropdown and then select "is checked." This will display only those rows only when it meets the criteria of the checkbox being marked.

You can find more info online via the link copied below.

https://help.smartsheet.com/articles/2482081-create-filter-criteria-to-control-data-in-report-builder

All the best,

Sandra

Genevieve P.

Hi @LCarter

I see that you marked Sandra's answer as not helping resolve your issue. Is it possible that both the items you are discussing are Sheets, not Reports? A Report in Smartsheet has an Orange icon and is sourced from a sheet, which means you can apply filters as Sandra said to show only rows with checkboxes.

However it sounds like you have two separate Sheets (which will appear with a Blue icon in your folder), and that you are trying to connect separate rows across these sheets. If that's correct, then I would suggest looking into either Cell Linking, see: Cell Links: Consolidate or Maintain Consistency of Data

An alternative would be to build a cross-sheet formula that pulls in data from one sheet to the other, however in this instance you would need a unique identifier across the sheets so the formula can find the matching row. See this Webinar around 18 minutes in for more details: Essential Formulas for Smartsheet Users

Cheers,

Genevieve

LCarter

https://community.smartsheet.com/discussion/comment/320379#Comment_320379

Capture 2.JPG

Capture.JPG

I was wondering if someone could please help with linking!

I have attached two photos for a reference. One is of the checklist (which is the one with the rows) and one is the report (which has all the tick boxes in the columns).

I am wanting to make it so when the payroll box is ticked on the checklist , that is pulls through to the column on the report.

Thanks

Lichelle

Update to Genevive, - I have a sheet and trying to pull something through to a report

Genevieve P.

Hi @LCarter

What sheet is selected as the Source for the Report?

If the Sheet with the Checkboxes is the one selected in the Report, then you just need to make sure that checkbox Column is included in the Report and it will show.

However if you're using a different Sheet for the source, then you will want to link the two Sheets together. Once you update the underlying source sheet, this will pull through into the Report. Does that make sense?