Your setup isn’t clear based on your description. Could you please share a screenshot or two of your table setup?
One part that I can comment on is this:
Formulas can’t change the contents of other fields. You could either trigger an automation with the formula, and that automation would check a box in another field, or the formula itself could output the :white_check_mark: emoji.