Variables in formulas

[Sev]

@myg_ge

What would be really useful is also having shared functions across formula fields. That would allow to overcome current UI-level limitations of presenting data while not requiring creating redundant formula-level piece of functionality over and over like this one:

ToText(Year(Deadline)) +
  If(
    Month(Deadline) < 10,
    "0" + ToText(Month(Deadline)),
    ToText(Month(Deadline))
  ) +
  If(Day(Deadline) < 10, "0" + ToText(Day(Deadline)), ToText(Day(Deadline)))

just to show date with leading zeros.

Yes, given that JS in Formulas has been rejected, shared functions in formulas, somewhat like “named formulas” in Coda, would be a helpful improvement for Fibery architects.