Formula column is not recognized as a number or date so cannot be used in other features (Conditional coloring or Automations)

Hey @aminster,

I don’t have an immediate solution but I made this feature request which would solve your problem, if you want to vote for it.

Hoping somebody else with have a workaround for you,
Laurent