Random circular reference

Michael Culley
Michael Culley ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have countifs formulas that work 99% of the time but every now and then when I login and look at the sheet, all of the forumlas display "CIRCULAR REFERENCE". I can't imagine that it is actually a circular reference so I'm wondering if it's perhaps a smartsheet bug. Any and all advice would be greatly appreciated.


Essentially I have a count if the owner is "Name" and if status is "Red". Again it always works fine but sometimes it randomly gives them all errors. I use this formula to show percent complete displayed by Harvey balls.