Hi @OrangeBird,
Regarding your question about getting formula results to trigger automations.
We’ve just published a detailed walkthrough in the community that directly addresses this challenge. It shows you how to use your formula column results to kick off automations.
You might find it really helpful: Copy formula result to other columns and trigger automations
Hope this helps you out!