I have a problem that I am currently unable to solve.
I have interpreted three status fields with “Switch” in order to assign numerical values to a status. For example, “critical” = 1, “normal” = 3 and “uncritical” = 6. I calculate a runtime from these three status columns. For example, if the number 9 comes out in total, then I know how long an operating time should be based on the criteria set in the 3 status columns. I can quickly work out the days and it works well. However, I cannot convert the formula column and the date displayed from it into a date field in order to work with the due date or to continue automations. What is the best way to do this or is it even possible?
Thanks in advance
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Hi Boris,
That’s not natively possible because to run a formula, you need to use a formula column and it is not available in automations. You would need to use a 3rd party app, like the Advanced Formula Booster which presents numerous advantages the first one being it is not using the Formula column. So you can cast the result of the formula to the data column of your choice.
There are many other features like:
1 formula can write to more than 1 column, reducing the number of automations used.
you can read and update columns from the current row (like the formula column), but also from the previous and the new rows, from the parent or sub-item rows, even from rows without the same group, the same board and other boards!
you can use up to 100 lines (100 instructions) in your formulas
you can use variables to temporarily store values so that you can re-use them all along the different lines of your formula