Forum Discussion
Checkboxes not automatically updating using COUNTIF
Hey, all, I'm using the following function to set the checkbox boolean of a cell based on the amount of other cells checked: In cell A1: =IF(COUNTIF(A2:A3=2,TRUE),TRUE,FALSE) The formula works, bu...
I have the same issue that just started happening. I am using formulas that apply things when TRUE is in the cell, so the checkboxes have worked good so far. If I TYPE in the cells TRUE or FALSE it will work as normal. I can even check the box, then go to the cell with the formula, double click to open up the cell for editing, click the green check mark, and it will refresh it. I’m about to submit a bug report to Microsoft.
