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.
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?