RYG automation based on percentage
I am hoping to get a formula to work for me I have read a million boards and non of them work for me!
What I am looking to do.
If percent >=100, red circle
If percent >= 50 and <100 yellow circle
If percent <50, green circle
this is the formula I am currently using;
=IF([Percent of budget spent]2 >= 100, "Red", IF(AND([Percent of budget spent]2 > 0, ( [Percent of budget spent]2 <50, "Yellow", "Green")))
Any help is appreciated!
Comments

The primary thing you have to know about smartsheets and percentage formatted columns is that the percentages are formatted as decimals.
1=100% and .5 = 50%.
Your formula, if you are using a % formatted column should like this.
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, ( [Percent of budget spent]2 <.5, "Yellow", "Green")))

That came up as #UNPARSEABLE, any other ideas?

Oh yes, there was an extra parenthesis in there. Try this one.
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, [Percent of budget spent]2 <.5, "Yellow", "Green")))

now it is saying #incorrect argument

Mackies,
The formula should be the following:
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, [Percent of budget spent]2 <.5), "Yellow", "Green"))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!