User Name
Password
AppleNova Forums » Programmer's Nook »

Google Sheets Checkboxes


Register Members List Calendar Search FAQ Posting Guidelines
Google Sheets Checkboxes
Thread Tools
EmC
Senior Member
 
Join Date: Jun 2004
Location: Columbus, Georgia
 
2022-02-10, 18:45

I have an array formula at the top of a column. It does some stuff and the result is either TRUE or FALSE in the cells underneath it. Works great gets true where it should be true and false where it should be false.

I want check boxes, but when I choose the cells and go to insert check boxes the array formula quits working with a warning that it is overwriting the data below it.

It seems like this should be easy, what am I missing? Nothing I try in google seems to bring up what I am looking for.

Currently I have changed the formula to return "✅","❌" instead of TRUE and FALSE but it isn't really my style. I just want the depression gray check boxes.

What Adobe Updater‽ What‽ What‽ WHAT‽
  quote
Posting Rules Navigation
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
Thread Tools
Similar Threads
Thread Thread Starter Forum Replies Last Post
Safari's Google search box: change to Google UK? Dorian Gray Genius Bar 0 2010-03-27 17:01
Google Now Lets You Save Any File Type to Google Docs ezkcdude Third-Party Products 1 2010-01-13 07:35
Google launches Google Public DNS (DNS resolving service) MBHockey General Discussion 2 2009-12-03 16:55
Google secretly reveals new browser project: Google Chrome Brad General Discussion 62 2008-10-28 15:16
Browser specific style sheets EmC Programmer's Nook 11 2006-02-26 07:44


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 14:42.


Powered by vBulletin®
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2022, AppleNova