Problem with formula in checkbox.
I have a formula in a cell check box:
=IF(COUNTIF(b3:b4, true) > 0, true, false)
It works great, but when you click on it, the formula is removed. It can be pressed accidentally, so I would like to protect myself.
Nothing checked.^|^
Only Monday3 is checked, and also Monday2 checked automatically. ^|^
I checked Monday2, and nothing else ^|^
Monday2 not working after checking(((((^|^
Answers
-
Hi @SanyaCLAUS
I hope you're well and safe!
I'd recommend converting it to a column formula because it can't be changed manually.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
The sheet sees the check you input as replacement for the formula. With checkbox's formula, it is better to have a Column formula and not Cell formula. Otherwise, you will always get that situation.
It is the same as a text formula. You can type "=Description@row" and it will copy the text or you can type anything else and the formula will disapear.
-
-
@Andrée Starå ,@Christian G. But I need to use separate ranges for each checkbox, for example monday5 in my screenshot will use a function for its range that is different from monday2... and also the cells of this range should be without a formula at all.
-
The only way to solve it then would be to use so-called helper columns to split it up.
Would that work/help?
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. 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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives