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'm having trouble with my nested formula and activating the Red, Green, Gray, Yellow ball based on the % compelte column.
=IF([% Complete] = IS BLANK, activate the RED ball
=IF([% Complete] = less than 100%, activate the YELLOW ball
=IF([% Complete] = 100% activate the GREEN ball
=IF([% Complete] = 0% activate the GRAY ball
Addtionally, if it is past the deadline and not green activated can it automatically activiate the Red flag symbol?