Circular reference help


Hello, this should be an easy question for a Friday.

I am trying to add weekly time spent on a task cell value to an actual time by task cell. The circular reference occurs because, obviously I am referencing the actual time by task cell and wanting the weekly time to automatically add to the total already in the actual time by task cell.

Column - Time spent by task

Cell value - 8

Column - Actual time spent by task

cell value - running total of weekly cell value for the life of the project

Is this possible or is the result always going to be a circular reference?

Sorry for the noob question. Thank you for the help in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!