Random circular reference

Random circular reference

edited 12/09/19 in Using Smartsheet

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. 

circularerror.png

circularerror2.png

circularerror3.png

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    When it throws the error, what steps do you have to take to fix it? Are there other people that are able to edit the sheet in any way?

  • Everything is locked so no other users can change anything. I typically take no steps and the problem fixes itself in the past. Right now it's not fixing itself. The part I'm confused about is why its coming up as a circular reference in the first place. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 09/05/19

    Hi Michael,

    Have you looked in the Activity Log to see if there are some details about what's happening?

    Hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I'm noticing now that the problem seems to be in my countif formula that is counting RYG balls. I'm not sure why it comes up as a circular reference. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    What's the formula?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • It's in one of the pictures i attached but here it is again:

    =COUNTIFS({ownership}, "BENITEZ, HOGUER", {new status}, "Red")

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ok.

    I'd be happy to take a look and see if I can find the reason for it not working.

    Can you describe your process in more detail and maybe share the sheet(s) or copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • None of the formulas show circular reference anymore. I'm pretty sure it's a bug with smartsheet. Doesn't make sense that it works fine for several months then suddenly shows circular reference, then suddenly doesn't show it. I haven't changed anything. Thanks for the help anyways.  

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Excellent!

    I'm always happy to help!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I have the same issue.

     

    I also agree it's probably a smartSheet bug.

    It happens to me I think on Mondays (back-up is done during the w-e, that might be a cache issue, I don't know).

     

    I also agree that my "Circular error" messages appear without any prior change on my side.

     

    Best,

     

  • I've had this same issue for months and submitted multiple enhancement requests with no response. It hinders our operations when this happens.

    Same as above, no material changes on our end. Seems to be triggered actually when a different piece of static data is changed in the sheet, almost as if the sheet is overloaded. However, there are less than 100 rows in that sheet, so that doesn't make sense to me. I don't do anything to the formula or source data, and it will randomly change back to the correct return value.

    Does anyone have an idea of how to keep this from happening for cross sheet references?

Sign In or Register to comment.