How to Use Checkboxes for Approvals, and Change the Text from True/False to Anything

[@matejmicka5887]

Hi, how would you make a checked box (TRUE) a different colour from when it's unchecked (FALSE)? A colleague sent me a document where the checked box has an unfitting colour and I can't figure out how to change it. Thank you.

[@BetterSheets]

I'd probably do it by using conditional formatting. Check if there's any conditiional formatting on the cell you're talking about. Or check if there's any apps scripts. go to menu: Extensions > Apps Script.

[@richbelanger]

Ive inbserted checkboxes and when checked I would like a "Y" or a "YES" in another colunm to pop up , how would I do that ?

[@BetterSheets]

Use IF() bettersheets.co/formulas/if

[@zander9486]

i want to assign a macro to a check box.i dont want to assign it to a button. would that be possible? thanks!

[@BetterSheets]

Can do Via Appscript. Add it to an OnEdit and then add some If() inside the onedit.

[@timelesstimesgoneby]

google sheets true false dates

[@BetterSheets]

What do you want to do?

[@timelesstimesgoneby]

@@BetterSheets I would like every time I check true it puts adate of last seen I have a list of tracking tv series

[@BetterSheets]

@@timelesstimesgoneby Maybe this video tutorial could help add a time stamp, or date: bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula