Is there a character limit in the Formula field type beyond which the formula no longer processes? It allows me to type in arbitrarily long formulas, but I notice that sometimes after a certain point the editor no long suggests auto-fill options when typing in the formula, and when I finish writing a long one, it seems like the end parts of the formula don’t process. Then when I go back to look at the formula, the end part of it is not present in the Formula box, even though I know I typed it in there.
(A separate, but related issue - the thing I am trying to accomplish with this is converting a month number from a date field to the month name. So my hyper-long formula starts
IF(MonthNum=1,"January",IF(MonthNum=2,"February",IF(... etc. If you know another way I can accomplish this that wouldn’t run into character limits, that’d be great too - thanks!