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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Cheers,

Genevieve

Jose Munoz

thanks

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.