Circular Reference Help

John M Lee

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.

Andrée Starå

Hi John,

I don't have the answer, but I got a tip. If possible, I'd recommend that you update your formulas with @row instead of specific row numbers. It's easier to maintain, and it doesn't take as much computing power.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

John M Lee

Thanks for the tip but I don't follow.  Do you have an example for one of the formulas above?

Andrée Starå

Happy to help!

Here's an example:

=[Program Addition Sent]8-1 would be =[Program Addition Sent]@row-1

Look here for more info about the @cell and @row functions.

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Hope that helps!

Best,

Andrée

John M Lee

Thanks!

Andrée Starå

You're welcome!