Change calculated column formula in table

[Keegan4123]

I have a large table, 30000 plus rows, previously we had a different calculation in the column and I have changed it to a new one. all is working well, except for when i create a new row, the table automatically fills the new row with the old formula, and it's broken. I have tried clearing all out, and autofilling with the new one, but even then every time a new row is added the old formula is being used.

Edit: I should note, all rows with the new formula are throwing a flag, for inconsistent calculated column formula

 

[Jeffrey Mahoney]

Do you some of your rows filtered?

 

[Keegan4123]

Do you some of your rows filtered?

no rows filtered, but I think I figured it out. I was overwriting the previous formula with the new one. I had to actually clear out every cell then reenter the new formula, seems to be working now.

 

[Alex Blakenburg]

no rows filtered, but I think I figured it out. I was overwriting the previous formula with the new one. I had to actually clear out every cell then reenter the new formula, seems to be working now.

The table can get confused if you have inconsistent formulas in the table.
Normally you can fix it by
• going to the cell that has the correct formula.
• Copy / Ctrl+C
• Hover over the column heading until you get a black downward pointing table, left click and it should select all the rows in that column/
(You can also use Ctrl+Spacebar)
• Paste / Ctrl+V
This will normally fix the issue so that the table recognises the new formula as being the one to use for all rows.