Hi, I need help to solve this:
I have 2 Tabs (tab 1 and 2), set up as checklist with the same source (components).
I would like to only show the components in Tab 2, if the corresponding component “is checked” in Tab 1.
Is there any way to do this?
Create a column in the data source of your sheet named “Checked”, it should be a boolean type. If its for multiple users make it a “user specific” column. Once you have that in place.
Put a checklist in tab 2 which has a filter: “checked” is not true
Put a checklist in tab 1 with the same data source but with the filter: “checked” is true
So basically when you check something in Tab 2 it will disappear and appear in Tab 1.
2 Likes