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.
RYGB Balls
I created a nested function to color designate the status of my projects tasks:
=IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue))))
The Red, Yellow, and Green balls work perfectly, however, when I select N/A from the drop down in the cell I get #INVALID OPERATION error message. Is there another way to write this function?
Is it not possible to automate the Blue ball?
Comments
-
Even the ability to leave that column blank(No ball) would be an option.
-
Hello. You're missing a closing quotation mark after Blue.
Try this: =IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue"))))
-
Ugh! Thank you! I guess I just kept overlooking that!
-
Easily missed! What clued me into it was that it was only failing on the blue.
-
Are you messing with the newbies? I can not believe it was "only failing on the blue"
=IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue"))))
This formula will not work.
You don't have a cell reference and you have =IF not IF in the nest.
This formula will work for row 13
=IF(Status13 = "Not Started", "Red", IF(Status13 = "In Progress", "Yellow", IF(Status13 = "Complete", "Green", IF(Status13 = "N/A", "Blue"))))
Newbies may try to copy your formula exactly and have no idea what they are doing wrong.
Craig
-
Oh my goodness! You are correct Craig. I totally overlooked the missing row numbers. When I said it was failing on the blue, I meant from her picture. She stated it would pass sometimes but not always. I completely concur with Craig - you must have row numbers in there to make the formula work.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives