Formula Column deleting formula randomly

I have a series of sheet calculating time allocation % in a formula and I set the column as formula column and locked it, after couple days for some reason the formula disappears, the column remains locked but the formula marking on the top of the rows disappears and my calculation also disappears from the whole column.
This is happening to different sheets
Best Answer
-
Hi @Josem29
We've identified an issue with formulas specifically in % Allocation columns used in Resource Management and our team is currently working on a fix. I don't have an ETA for when this will be resolved, but please know we have identified the bug and are actively working on a resolution!
Cheers,
Genevieve
Answers
-
I would suggest starting with looking at the Activity Log to see if other users have been changing anything.
-
That was my first reaction , but no. Im the only one managing these sheets and the Logs shows only my actions. It has to be a bug into the Sheet Code
-
At this point then I would suggest reaching out to Support to see if they are able to help.
-
great thanks, I was hoping someone had the same issues. the other option was maybe the formula not being liked by the sheet and deleting it in some kind of maintenance process running on these sheets
-
Hi @Josem29
We've identified an issue with formulas specifically in % Allocation columns used in Resource Management and our team is currently working on a fix. I don't have an ETA for when this will be resolved, but please know we have identified the bug and are actively working on a resolution!
Cheers,
Genevieve
-
thanks
Help Article Resources
Categories
Check out the Formula Handbook template!