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

[Marlon_Xavier_M]

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]

What was the exact formula in your Show_If?

[Marlon_Xavier_M]

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

[Aleksi_Alkio]

What you mean by “Column number”?

[Marlon_Xavier_M]

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]

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_M]

Thanks

[Marlon_Xavier_M]

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

[Aleksi_Alkio]

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

[Marlon_Xavier_M]

ok, thanks