Circular Reference Issue

Gunderson Rookie
Gunderson Rookie ✭
in Formulas and Functions

We have had the same worksheet for over 2 years and this past week, we started getting the #Circular Reference Issue.

Screenshot 2025-05-16 081721.png

We have trainings and update our employee database (2nd screen shot) weekly and this week the "Clock No" column in the training database worksheet (first screenshot0 in the "Clock No" column is coming back Circular Reference error?

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion

    @Gunderson Rookie IF it changed suddenly the most likely culprit is a formula change on the source sheet that's causing the issue.

    If you found this comment helpful. Please respond with any of the buttons below. AwesomeπŸ–€, InsightfulπŸ’‘, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!