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

  • Genevieve P.
    Genevieve P. Employee
    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!



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!