Howto make checkbox change dropdown value in another field

[SSUUOO]

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

Backlog-ToDo-InProgress-Done

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.

[Elias_Gomez_Sai]

SSUUOO:

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.