Automation error Formula to text

[station]

Hi community members!
I`m trying to sync change between 2 columns on Formula.
(or…Is it possible??)

①:A specific textbox update
(Formulas with text appended under certain conditions)
②:IF①`S record created,A specific “Checkbox” becomes :heavy_check_mark:

Any ideas on how to solve this?
(or recommend “automation”??)
Thank you!

[Justin_Barrett · Accepted solution]

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:

station:

IF①`S record created,A specific “Checkbox” becomes :heavy_check_mark:

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.