Format cell as a checkbox (TRUE, FALSE)
Offer a format that displays the boolean value of a cell as a checked box if TRUE, unchecked box if FALSE, grayed box if text or other nonbool.
Bonus: Toggle value OnClick would be intuitive.
Lots of uses for this. Current options are awkward for users. Yes/No dropdown is not as good as a checkbox for touch/mobile.

5 comments
-
Jason Szotak commented
Google Sheets does this with data validation which works perfectly. Time to catch up MS.
-
Anonymous commented
i'd love this
-
Anonymous commented
would love this too
-
David Benaim commented
Yess this would be lovely! Better than yes/ no drop down
-
Thomas commented
This would be great and usefull every day!