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.