Hello Group,
I have a question about whether in Monday I can create a constant that serves as a parameter to later use in the formulas, without having to create a column with a number field for that.
Is this possible?
Example:
Value 1 = 10
Value 2 = 20
Hi Juan,
No, it is not. If you want to be able to use variables (constants) in your formulas, you may want to look at the Advanced Formula Booster.
It is a 3rd-party app with a syntax editor which can accommodate up to 100 lines of code, accepts variables, allows you to access (ie. read/update) columns from other items than the one triggering the formula, does not use the formula column at all (avoiding its limitations) and is able to update multiple columns at once (greatly reducing the number of automations).