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