Hello Community,

I'm trying to establish an RYG Status column formula in my sheet based on values in three other columns. One is a STATUS column with drop-down selections of Completed, Not Started, In Progress. The other two are date columns START DATE, FINISH DATE. 

Here's the statements without proper syntax: 

IF(STATUS)= Completed, Green

IF(STATUS)= BLANK AND (START DATE)>TODAY, BLANK(no symbol)

IF(STATUS)= NOT STARTED AND (START DATE) <TODAY, OR IF(STATUS) = IN PROGRESS AND (FINISH DATE) <TODAY, RED

IF(STATUS) = IN PROGRESS AND (START DATE) < TODAY AND (FINISH DATE) > TODAY, YELLOW

Putting all these in one statement has me baffled.  I've tried this but am getting #UNPARSEABLE error

=IF(AND(STATUS@row = "Not Started", ([START DATE]@row < TODAY()), OR(STATUS@row = "In Progress", ([FINISH DATE]@row > TODAY())), "Red"), IF(AND([STATUS]@row = "In Progress", OR([START DATE]@row < TODAY(), [FINISH DATE]@row > TODAY())), "Yellow"), IF(ISBLANK([STATUS]@row), ""), IF([STATUS]@row = "Completed", "Green"))))

I feel like my order of operations is incorrect as is something in the syntax. 

Any help would be greatly appreciated.  

Thanks

Eric