#Circular Reference when automating Yes,Hold,No decisions

r@ndom_w@lker

Hi,

Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula,

=IF([Lead Result]1="Win",Status1="Yes",IF([Lead

Result]1,="Negotiating",Status1="Hold",Status1="No"))

Posting a screenshot of my sheet for reference, Thanks in advance for the help!

-Shiv

J. Craig Williams

You don't need to reference the cell where the formula resides. In fact, you can't*.

=IF([Lead Result]1="Win","Yes",IF([Lead

Result]1,="Negotiating","Hold","No"))

should work (I did not test it).

Craig

*This also means you can not have a formula in one cell that sets the value in another cell.

 

laurie.johnson2bluespiremarketign.com

Perfect timing. I am actually stuck on similar questions.  I want to be able to have the symbol automatically inserted based on if we are over or under budget. How would I do that?

r@ndom_w@lker

Try This in the column where you want the symbol inserted. I assume that you are using RYG symbols. 

=IF([Budget]1 < "Some number", "Red", IF([Budget]1>"Some number","Green", "Yellow")). Pretty much the same thing that craig suggested

r@ndom_w@lker

Thanks for pointing this out Craig! Have a fantastic weekend