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.
RYG balls based on task completed
I have a sheet where I want to update the next columm based on the RYG color of the first.
For example: If Column 1 = Green then I want Column 2 = Blue
I think I am close on the formula but it just isn't playing nice.
Thanks!
Comments

Ruth,
It would be helpful if you pasted your formula so I could see.. but in lieu of that try this formula example from the Formula Template:
=IF([Value 1]133 = "High", "Red", IF([Value 1]133 = "Medium", "Yellow", "Green"))
https://www.smartsheet.com/solutions/smartsheetformulaexamples
Hope that helps.

Thanks Tim. Here is the formula with some of your help incorporated.
=IF([Individual Drug Cleanup  V@V]1297 = "Green", IF([Susan Review Formatting]1297 = "Blue"))
If column "Individual Drug Cleanup" on row 1297 turns Green I want the "Susan Review Formatting" column on row 1297 to turn Blue.
Seems to me there should be a Then for the IF.

Thanks for the extra detail. The Nested IFs assume a "Then". What you are missing is an "else condition" after the word "Blue". The else is written as another comma after the word "Blue" and then whatever the else should be.
On putting the 2nd column in the formula name, I made the same mistake.. since you are referencing the "Susan Review Formatting" which is the same column the formula is in, it is a circular reference.
So I assume you have the column "Susan Review Formatting" set as a Symbol/RYG Balls Property type... if so, put the formula in this cell, then the correct formula would be this:
=IF([Individual Drug Cleanup  V@V]1297 = "Green", "Blue", "")
written out, it says, If the RYGBall in column "Individual Drug Cleanup  V@V, row 1297 = Green, then make "Susan Review Formatting" 1297 cell = Blue, else "blank".
hope that helps!

Worked like a charm, thank you!!
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives