Make a checkbox that is used on 2 sheets show the same value.

ClanMcDe

I have a checkbox called "Pause" that is located on a sheet called "Schedule Sheet" that needs to be the checked/unchecked based on a "Pause" checkbox located on a sheet called "Periscope Request Tracker". if the checkbox is checked on the Periscope Request tracker then I need the checkbox to be checked on the Schedule sheet and vis-a-versa. The formula I am trying to use is:

=ISBOOLEAN(COUNTIFS({Schedule Sheet Range 2}, [Task Name]@row, {Periscope Request Tracker Range 1}, <>1))

and does not work correctly. Unsure what I need to make the checkboxes work together.

Sarah Keortge

Got it, thanks! Is [Task Name] the unique value you would be matching on in both sheets?

ClanMcDe

https://community.smartsheet.com/discussion/comment/456965#Comment_456965

HI Sarah, that worked! Thanks for the idea! 👏🙌

Sarah Keortge

Can you please clarify whether there will only ever be one cell checked/unchecked on each sheet or will you have multiple rows that could be checked/unchecked and matched up across the sheets? If it's just one cell, why not use a direct cell link instead of a formula?

ClanMcDe

https://community.smartsheet.com/discussion/comment/456832#Comment_456832

Hi Sarah,

I am updating multiple rows across the sheet. so the formula will be a column formula.

Sarah Keortge

Got it, thanks! Is [Task Name] the unique value you would be matching on in both sheets?

ClanMcDe

https://community.smartsheet.com/discussion/comment/456940#Comment_456940

It is.

Sarah Keortge

If you have access to the Data Mesh premium app, you can use that to sync the checkboxes.

If you don't have access to it, then give the INDEX/MATCH function a try. Create a helper column in each sheet to return the checkbox value from the other sheet like so:

in schedule:

=INDEX({checkbox column from tracker},MATCH([Task Name]@row,{task name column from tracker},0))

in tracker:

=INDEX({checkbox column from schedule},MATCH([Task Name]@row,{task name column from schedule},0))

This will look for a match to the task name in the other sheet and return the associated checkbox value.

From there, you'll create an Automation in each sheet to check/uncheck the checkbox based changes to the value of the MATCH/INDEX result. For instance, if Task A in the tracker changes to 'checked' then the INDEX/MATCH value on the schedule will update to checked so you can have an automation that listens for changes to the INDEX/MATCH helper column and either checks or unchecks the box in the schedule based on a condition.

ClanMcDe

https://community.smartsheet.com/discussion/comment/456965#Comment_456965

HI Sarah, that worked! Thanks for the idea! 👏🙌