Howto make checkbox change dropdown value in another field


I am using a Kanban view most of the time and I have kanban columns for


These columns are Dropdown statuses.

I would like items that have a checkbox pressed (checked) to immediately move items to “Done”.

I understand (I think) the IF statements relating to checkbox being 0 or 1, but I’m not sure how I can change a dropdown to read 1 = Done.


You can’t change other fields with a Formula field within Airtable, but you can automate it with Zapier or Integromat.