Ability to Choose what type a formula column returns

Right now, it seems monday treats the result of a formula column as a number / string,

However, it would be really useful if we could “cast” the result as a different type, such as a date, timeline, or a status. The type could be implied by the result or could be set by the user. And then use the native tools that are already available for the types.

The reason is twofold:
1. Mainly for subitem rollups, which right now treat any formula column as a number. So if a formula column on a subitem returns a date, the rollup will look like 20,260,429 instead of Apr 29 2026, and since you can’t access rollups with a formula column, there is no way to format it nicely.
2. For much nicer formatting, especially as a status with giving it colours. Imagine if a formula column could look at a few number columns and be a yellow “warning” for red “error” if it sees something wrong. I’m aware that this is currently possible using third-party tools such as Make or General-Caster, but it would be nice to have client-side native support.

I want to have a board where each item is a bundle of lessons, and each subitem is a lesson in it, with a date and status whether it happened or not. But becuase of this limitation I wouldn’t be able to get certain data - such as the last lesson that has the happened status, and have to have a date and status column for each lesson, which isn’t flexible to the amount of lessons there may be, and causes quite a lot of clutter.

Thanks for reading!