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.
Nesting if functions for blank cells
I'm trying to create a formula with the RYB balls that says if two date columns (Start and Completed) are blank, then the value should be a red ball. If there is a date in the start column but not in the completed column, then the value should be a yellow ball. If both columns have date, then the value should be a green ball. I got as far as the formula below, but am getting an unparseable error. Any help would be appreciated!
=IF(AND(ISBLANK([Start Date]1), ISBLANK([Completed Date]1)), "Red"), IF(AND(ISBLANK([Completed Date]1), NOT(ISBLANK([Start Date]1))), "Yellow")