Drop down with valid if issue

I’m having a problem with valid if, with the column four I just get the error “This entry is invalid”. I don’t know if the problem is with the column type, I tried to change the format to number directly in my sheet, at first it worked but on the second try it doesn’t work anymore. What should I do?


.


Is there any way to do the same thing with the column type REF?

Try change Precio from type number to type decimal?

1 Like

I tried but it didn’t work

Not sure if I’m following completely. Are both Estadasicas[Precios] and Lists de precios[precio sin iva] of type Decimal?

And what does this question mean?

Is there any way to do the same thing with the column type REF?

1 Like

Precio should be an output and not input. You need to define a virtual column whose value will be Precio when all the other drop downs are selected.