Solved: Drop down with valid if issue - Page 2

ReyRSL12 · 12-18-2022 09:46 PM

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?

gregdiana1

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.

View solution in original post