Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

#Circular Reference when automating Yes,Hold,No decisions

edited 12/09/19 in Archived 2017 Posts


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


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


Screen Shot 2017-12-01 at 11.08.53 AM.png


This discussion has been closed.