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.

Change the value of a cell from the formula results of another cell

Ray Vigo
Ray Vigo
edited 12/09/19 in Archived 2015 Posts

I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the  % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete it will automatically set the Status to "Complete" or vice-versa, if I enter Complete in the % Complete that it will set the % Complete to 100%. That's it.



  • Travis
    Travis Employee

    Hello Ray! Yes, it is possible to create a formula that will adjust values in a cell based off the values of another cell. You would have to decide which column you want to add the formula to - you cannot add it to both columns have them each column update the other based on which one you edit. 


    Check out this blog post which explains how to automate RYG balls. These same steps can be used to automate other columns types in your sheet: http://www.smartsheet.com/blog/support-tip-automate-RYG-balls


    I also wrote a post back in May about how to write formulas for symbol columns which you may find helpful. Check it out here: https://community.smartsheet.com/announcement/working-symbol-formulas



    If you are having trouble building your formula, show us the formula you have build and we can help you troubleshoot! 

This discussion has been closed.