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

Formula1.PNG Formula2.PNG


Tags:

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!

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!