SOLVED

Table on a Excel file on the cloud does not update properly

Copper Contributor

Hello!

I have 5 Forms on OneDrive, with their respective Excel files. 

 

The last columns of every Excel file have formulas and the table has format, so every time someone answers the form a new line is created and the formulas must be copied.

 

This, however, only works on 3 of the 5 Excel files.

 

This is the layout:

jcrojas1_0-1688152785829.png

The formula states that, if column BK (Bajas) has "BAJA" as value, then the value on colum BL (Estusuario) will be "Baja". Otherwise, this value will be "Activo".

 

But the formula is not updating automatically anymore:

jcrojas1_1-1688152944608.png

I updated the file manually, but the error persists:

jcrojas1_0-1688153322619.png

 

It seems like Excel is not recognizing the column Bajas when updating with a new line, but I don't know what is happening.

 

Can you help me, please?

And please, excuse my bad english. 

 

1 Reply
best response confirmed by jcrojas1 (Copper Contributor)
Solution

Welp...

I fixed my issue by deleting my old column and creating a new one with the same formula. This new column adds the formula as intended once a new row is created.

I still don't know why the deleted column stopped to work on the first place.

1 best response

Accepted Solutions
best response confirmed by jcrojas1 (Copper Contributor)
Solution

Welp...

I fixed my issue by deleting my old column and creating a new one with the same formula. This new column adds the formula as intended once a new row is created.

I still don't know why the deleted column stopped to work on the first place.

View solution in original post