Help with Formula ¿is this possible?

[daniel.cubicup (Daniel)]

Hello,

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!

[BiancaT (Bianca Taylor)]

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?

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @daniel.cubicup,

Try:

CODE({Status1}-CODE({Status2})

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

[daniel.cubicup (Daniel)]

Thank you very much Gilles, it works perfect!