IF And
bday2329
✭✭✭✭
Good Day,
I need so assistance, I am trying to do the following
I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met
if my "# of Days" column is > 138 and my "% Complete" column is < 50%
Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)), "Yellow", "Green")))
Where am I going wrong I get #unparseable error
Comments
-
It looks like you have too many parentheses in your formula. Try this one:
=IF(AND([# of Days]2 > 138, [% Complete]2 < 50), "Yellow", "Green")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!