Need help with pulling checkbox into another sheet based of certain criteria

Keith McCloskey

Hello,

I am looking at an existing sheet and trying to pull that information over to another sheet. The current column is utilizing a check box and I would like to pull that information over based on a specific number that is being utilized by both sheets. Any assistance would be great.

Paul Newcome

Try something like this in the new sheet's checkbox column...

=INDEX({Other Sheet Checkbox Column}, MATCH([Number Column]@row, {Other Sheet Number Column}, 0))

Keith McCloskey

I tried that but get #invalid column value

=INDEX({H264 REVERT Data Loss}, MATCH([Store Number]1360, {H264 REVERT SLDB Loc}, 0))

H264 REVERT Data Loss - This column is the one that has the checkmark

MATCH([Store Number]1360 - based of specific number on my new sheet

{H264 REVERT SLDB Loc} - This is the number I am comparing it to from my sheet

Andrée Starå

Hi Keith,

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@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

@Keith McCloskey

Double check the data in your ranges. Is that error present in any of the cells in those ranges?

Is the column containing the formula set as a checkbox column?

Keith McCloskey

OK I did realize my mistake of not editing the column properties but see attached with what I am looking at even if I go 0 or 1 I do not get anything in the box.

Paul Newcome

Have you checked that you are using the correct row number in your formula? If the formula is referencing the [Store Number] column on the same row, then update the formula to use "@row" instead of an actual number.

[Store Number]1360

changes to

[Store Number]@row

Also double check that your ranges are in fact covering the correct portion(s) of the other sheet.

I have had it happen to me before where I was clicking a little too fast when creating a cross sheet reference. I would click on the column header before the sheet was fully loaded. Then when the sheet was finally fully loaded, the selection would revert back to the home cell (top left corner), and I would have to reselect the column header before creating my reference.

Keith McCloskey

Thanks for the help on this it was a matter of clicking to quick and not letting entire field populate.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as the "Accepted Answer" so that others can know that a solution has been found.