Circular Reference Help

John M Lee
John M Lee ✭✭
edited 12/09/19 in Formulas and Functions

I know this is a long shot but here goes.  I have 2 sheets:  a calculation/capture sheet and a reference date calculation sheet.  The first gets information from a web form and does a few on-sheet look-ups and calculations.  Two pieces of data are pushed to the second sheet where date calculations occurr and the 3 resulting date sets are returned to their own fields/columns on the first sheet.  

The weird thing is if I erase the formulas in the fields currently showing Circular Reference Error and press save, they work!  Until I close the sheet or press Refresh.  Why do they work sometimes and not after??   Any help or advice would be wonderful.


Attached are screen shots of the 2 sheets and all formulas being used.

Sheet 1 - Capture & Calculation Sheet.JPG

Sheet 2 - Date calculation reference sheet.JPG

SS Formulas.JPG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!