Why do my Cells revert to previous value after formula saved properly?

LeeAnn Friemoth

I click save and then it does this:

If I double click in the cell to see the formula it adds a ' at the beginning

Andrée Starå

Hi @LeeAnn Friemoth

I hope you're well and safe!

Strange!

Is the column used in the Project Settings?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

LeeAnn Friemoth

This is from my PMO Summary Closed Rollup sheet

Andrée Starå

@LeeAnn Friemoth

Is that column selected in the Project Settings?

LeeAnn Friemoth

No it is not in the project settings.

Andrée Starå

@LeeAnn Friemoth

Strange!

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

PSExcellence

Same thing is happening to me. I update a formula to a new range and save. Later, I go back and it has reverted to the old range.