Help with Formula ¿is this possible?


I wonder if is possible use formulas based on Status.

My example:

In the right column, we need to calculate de difference between two letters ( eg. G-D = 3)
Can we use formulas based on status?

Thank you for all your help!

Hey Daniel!

You can integrate status columns into your formula for sure! That said, you’d need to ultimately set up a seperate formula that identifies the value specific to the letter (i.e. G = 5), in order for the calculation to work in the formula, otherwise there is no numerical value attached to the letter - does this make sense?

Hi @daniel.cubicup,



For more hidden functions, see The monday Hidden Functions – The Monday Man

1 Like

Thank you very much Gilles, it works perfect!

1 Like