Hey @arnold_wikey and @JCorrell
I wanted to chime in as a formula-lover myself! I do agree this could be documented better and i appreciate your effort into sharing the knowledge you’ve gathered via testing
@JCorrell to add on to your list, here are the things I’ve found myself for FORMAT_DATE:
Q - Will show the Quarter of the date (Jan, Feb and March would show 1, for example);
Do - Day ordered (16th over just 16) - generally, adding “o” would make the value ordered.
W - shows the Week number of the date value;
L - This would format the date as Month/Day/Year
For TEXT, generally most things fly in my experience, and I haven’t found anything particularly useful… except “:” as a token. This takes a numeric value within your board and formats it as a time value, where 3600 would equal 1 hour (as in 3600 seconds):
I hope this helps a bit I’ll share your feedback with the team, as I do think this could be a much smoother process than trial and error.