Currently Formula column has many limitation. I cannot use it in Automation. I also cannot copy it value. I suggest a change in structure of column: Any column has 4 parts: Type, Value, Format, and Formula.
- That means any column can have formula. This will also resolve many other problems.
- That also means number, datetime column can be formatted.
- This may also resolve issue with Mirror column. You may implement Mirror as a formula function. Or you may imply it in the UI/UX (i.e. people can still configure Mirroring although it’s a formula behind the scene).