Hi David,
As far as I know, monday.com is already working on it. Please find this thread: Include formula columns in automation recipes - #304 by RobertParsons
Meanwhile, as a temporary workaround you may try resynced.io app: https://monday.com/marketplace/listing/10000688/resyncedio
Here’s a step-by-step guide how you can bring formula output into regular column rather than formula and thus be able to use automations: https://www.youtube.com/watch?v=f51NaLaeT3I