I'm working on a Google sheet actually (only for fun) and I'm actually stuck on something, as I said in the title, I want to keep a checkbox value in Google sheet.
I will explain my problem.
I'm doing a sheet of some information who will appear when I change the value of a dropdown list. But I want to be able to check a checkbox in one Dropdown item and when I change this item, have the checkbox who will take the value of the other item. A little example:
I have 2 dropdown item: one called poney and the other called horse, I check the checkbox while I was in poney and I change to the horse. I want the checkbox value go to false and when I go back to poney the checkbox retake the value true
EDIT: I add a Google sheet example on how I use it: https://docs.google.com/spreadsheets/d/1ySbHJJohneH_2hS3_lhl2Va-U4ejan-jeW0btbaMGlw/edit?usp=sharing
I hope someone can help me with that!
Best Answer
demo spreadsheet
=IF(B1=FALSE; TRUE; FALSE)
TRUE
/FALSE
let D1 cell be an auxiliary formula which you can hide:
=IF(A1=TRUE; FALSE; TRUE)
demo spreadsheet