Linking a check box to a column in a table

[tbrynard01]

I have a check box on a worksheet that I would link to a field in a column. The issue that it is a table and I would like to be able to have the linked field always be the new line in the table. is this possible?

Thank you.

 

[smaur]

I'm assuming the field in the table contains a boolean either 1 or 0 or "True" or "False" and that you would like the check box to reflect the boolean value in the last row a specific column in a table. If that is the case, I would place the formula below in any cell you prefer, and then reference that cell in the "Cell link" field of the checkbox control. Of course replace "Table" with your table name and "Column" with the name of your column


=INDEX(Table[Column],COUNTA(Table[Column]),1)

 

[tbrynard01]

Thank you so much