Why Can't I Check a Checkbox in a report?

kirsten112286

I haven't had issues with this in the past, it suddenly is no longer working. So weird.

I have a report that has 4 columns that can be checked / unchecked.

Today, 2 of the columns are allowing me to check/ uncheck while in the report, (which will update the sheet that it pulls from), and the other two columns are unable to be checked / unchecked while in the report. The permissions have not changed - I am an admin and another of my colleagues trying to check the columns is also an admin. The columns are not locked. The checkboxes work perfectly fine on the sheet it is pulling from.

Any suggestions as to why this is not working?

Paul Newcome

A formula in a cell will render it unable to be edited in a report regardless of column type, permissions, locked vs unlocked, etc.

Andrée Starå

Hi Kirsten,

Have you or someone else change anything with the columns?

Double check the columns in the report so the ones you’re seeing is the ones active in the sheet(s).

Did that fix it?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

kirsten112286

Thank you, Andree! Unfortunately, that's not the issue. The columns are active within the Summary sheet that the report is pulling from. What's odd is that there was a formula in ONE of the columns that I included for automation, and once I removed that, THAT column works now within the report when checking and unchecking. This is super odd, however, because the column isn't restricted to checkbox only and having a formula within that column should have no bearing on whether or not it can be checked / unchecked within the report that's pulling it in.

However, there is still one column that will not allow check / uncheck of the checkbox within the report and there IS a formula in another sheet that is looking at this column specifically for a "COUNTIF" formula. That shouldn't prevent this column from working within the report though, right? I have never had that issue before...

Paul Newcome

A formula in a cell will render it unable to be edited in a report regardless of column type, permissions, locked vs unlocked, etc.

kirsten112286

Awesome, thanks, Paul! That worked!

Building in extra columns for counts (booo more columns), and redo-ing a bunch of calcs :) Fun Tuesday if I've ever heard of one! Have a great day.

Paul Newcome

Happy to help! 👍️

Don't worry though... I know the feeling all too well of having to revamp unexpectedly. Ugh!!

Andrée Starå

@kirsten112286

Yes, formulas will "lock" the cells in a report.

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée 

Meredith Luschen

I'm having this same issue but there are no formulas in my sheet! one sheet (no formulas) and one report. check box column works fine in sheet but will not show a checkbox on report! any suggestions on how to fix?

Paul Newcome

@Meredith Luschen Do you have at least editor permissions on both the sheet and the report? Was the checkbox column definitely added to the report?

Scandi