Until Monday supports formula columns, check out the General Caster app. I answered a similar question on another board if you want more details.
But the short version is General Caster calculates the formulas outside of the Monday board and then cast it to basic text or number columns. I’ve been using it for all sorts of Automation workarounds. Hope this helps!