I have a SHOW IF working but, EXAMPLE not(isb...

(Marlon Xavier Medina Cisneros) #1

I have a SHOW IF working but, EXAMPLE not(isblank…) and when I add a column this stop working. The I have to change the SHOW IF with the new column number…

This did not happen before…

What do I did?

(Aleksi Alkio) #2

What was the exact formula in your Show_If?

(Marlon Xavier Medina Cisneros) #3

this one: NOT(isblank(([Producto/Servicio.])) )

(Aleksi Alkio) #4

What you mean by “Column number”?

(Marlon Xavier Medina Cisneros) #5

The new column. It is because i use 4 columns with the same name but apsheet rename them witch column_1, column_3…

And, when I add a column thisnames change.

So the SHOW IF stop working and then I have to rename the formulas…

(Aleksi Alkio) #6

Okay… you should rename your columns in a way that they will have an unique name. Then this kind of behavior won’t happen again.

(Marlon Xavier Medina Cisneros) #7

:slight_smile: Thanks

(Marlon Xavier Medina Cisneros) #8

Is there a way to FIND an Expresion and REPLACE for this new expression ?

(Aleksi Alkio) #9

Not directly. When you change the column name and “Verify and save”, you will find them through error messages.

(Marlon Xavier Medina Cisneros) #10

ok, thanks