Why Can't I Check a Checkbox in a report?
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?
Best Answer
-
A formula in a cell will render it unable to be edited in a report regardless of column type, permissions, locked vs unlocked, etc.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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...
-
A formula in a cell will render it unable to be edited in a report regardless of column type, permissions, locked vs unlocked, etc.
-
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.
-
Happy to help! 👍️
Don't worry though... I know the feeling all too well of having to revamp unexpectedly. Ugh!!
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
@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?
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.9K Get Help
- 337 Global Discussions
- 195 Industry Talk
- 427 Announcements
- 4.3K Ideas & Feature Requests
- 130 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 450 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives