Formula Column deleting formula randomly

Jose Munoz

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

Genevieve P.

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

Paul Newcome

I would suggest starting with looking at the Activity Log to see if other users have been changing anything.

Jose Munoz

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

Paul Newcome

At this point then I would suggest reaching out to Support to see if they are able to help.

Jose Munoz

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

Genevieve P.

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

Jose Munoz

thanks