Allow to update display formats
Similar to Sheets/Excel functionality, I’m looking to change the display format of a date field, and this being updated by the end user too if desired. The same way that we can change it when grouping by a date field, and how Currency fields can be summarized from the Show Me section.
Eg:
I know that for some cases is possible to workaround this limitation by creating an additional calculated fied within the object like Year Number, but there are some that are not possible and even if they were, they wouldn’t achieve the desired sorting because strings do not behave like dates. Consider the Quarter of Renewal Date as example, a string would order by groups of quarter first: Q1 2025, Q1 2026, Q2 2025, but if only the display format is changed, it would honor chronological ordering:
