May 08 2020 05:15 PM
I keep getting this error message pop up on my spreadsheet but it doesn't seem to fix itself once I click on the Restore Calculated Column Formula. Whenever, I do this and then sort within the table of calculated cells the problem reverts back.
May 09 2020 05:55 AM
That's not an error, that's alert, more about it here https://support.office.com/en-us/article/inconsistent-calculated-column-formula-5d2735ec-a8f2-4a06-a...
You may ignore it.
May 12 2020 04:55 PM
@Sergei Baklan Hey, thanks for your response. I noticed that the calculations were incorrect however so I can't ignore it.
Oct 21 2022 09:50 AM
@arperez Hi, did you by chance figure this out. Mine just started doing this and not adjusting the formulas as it should, and has in the past. I'm sure it's a setting somewhere, but I can't figure it out.