Allowing Circular Reference

Options
Shane Shelton
edited 12/09/19 in Smartsheet Basics

I would like to run a calculation with a circular reference  =IF(Date1 = [1]1, 100 - Total1, [1]3‌). This allows me to keep the cell as is if the IF statement is false. Is this possible? [1]3 is the circular reference.

Comments