Cells with a formula date calculation are changing automatically...help!!
Hello all - I'm throwing this out there as it's completely stumped us and I'm hoping this has happened to someone else and they know what's going on!
We have a sheet that we have formulas created to calculate a backward scheduled start and end date for specific tasks (dependencies are not enabled). The February 8 date below is brought in from another sheet via index/match. (Note that I will try adding the files in a reply comment as I can't seem to do it on this original post). For some reason at 4:06pm yesterday, any time someone goes into the sheet/saves or ?? it triggers what looks like a recalculation of the formula and all the fields that have a formula in start/end target go blank, and then they go back to the original date calculated. What's funny is that looking at the sheet you never see the blank cell. Then at 4:34pm it stops.... I went into the sheet after that, made some changes, saved, exited, went back...nothing. And this morning it still hasn't happened. It wouldn't be a big except 1. It's really bugging me not knowing what's causing it! and 2. We have an automation set up to notify the assigned person if the date changes...and the blank does register as a change, so the person is getting notifications of dates changing, but no change shown. It's creating a lot of noise. I check the Activity Log to see if there is anything that could be triggering it and I don't see anything. (I'll try and post that as well).
Does anyone have any thoughts on this? I'm to the point where I might start from scratch & recreate the sheet, manually re-enter all the data and find all the reports it is referenced on and relink! Please help, because I REALLY don't want to do that! :)
*Edit - I cannot add a screenshot/file/image. It just keeps popping up the "add file" box to pick one even after I've done so. Any ideas there as well so I can add them to further help explain my situation?
**Turns out it's just that Edge is temperamental! Chrome worked fine...see below! :)
Help Article Resources
Check out the Formula Handbook template!