Using Automations To Change Other Columns and Subtasks

Hello, how may I set an automation for a column link to trigger the change in another column (or subitems column)?

Example, when a link is added to this link column, change the label column (currently set at link received yes or no?) to YES.

Similar example: When the numbers column is noted as 100% change the status column to DONE. If the numbers column is anything under 100% but above 0%, change status column to WORKING ON IT. IF the numbers column is 0% change status column to NOT STARTED.

I’ve been researching the automations and most look to trigger an action of email, or date change but I don’t see where I can trigger a change in other columns or subcolumns based on a change in a different column.

Thank you for your support!