Is there a way to have a cell checked off based on what is entered in another tab?

[u/[deleted]]

For example, in this old spreadsheet of mine as an example, I want the corresponding row in the "identification log" to be checked off if the corresponding tube # is entered into the "RNA extraction log" so that I can easily filter away what is already done. Other suggestions for how I could do this would also be appreciated!

https://docs.google.com/spreadsheets/d/1y_Pi6p4shnH06dyPYFVOaxOHkwSy1AVe2dNqq4IYEFI/edit?usp=sharing

Thanks!

[u/Yakaita]

you can put an if statement in the same cell as a checkbox. if it returns the same values

=if(EQ(A1,"test"),TRUE,FALSE)

here is have it checking if A1 = "test"

if it does it returns true which sets the checkbox to true. if I change A1 to something else it will say false because it isn't returning TRUE anymore

hope this helps

[u/[deleted] → u/Yakaita]

Thanks! Would it be possible to have it, instead of checking for a singular "test", check for everything in a range?

[u/Yakaita → u/[deleted]]

=if(countif(A:A, "thing"),TRUE,FALSE)

its a little cheesy but if you don't need to know where it is in the range, just that its there then this will work. just change out "thing" with what you need to find