The Youtube link above gives a formula to change the checkbox property field based on select property field "Status" to be checked or unchecked. But what if you want the "Status" (select property field) to change based on your checkbox? I need a formula to change the status based on whether the checkbox is checked not based on what the status (in select property field is).
For example in a task database I may have a task with a checkbox that says Completed if I check the box I want the status to automatically go to Done is that possible or am I just stuck to the filtered view of the data?
Or a Reading List Status