RYG Formatting - Formula for Populating Status using %Complete and Finish Date

HELP!!! I am trying to populate my Status field, using RYG formatting (using the % Complete and Finish Date). The cell displays #UNPARSEABLE. I am not sure what I am doing wrong. I have been reading through the comments in the community and just cannot get this right. 

I used this formula in Excel and it worked, but when I copy it into Smartsheet, it does not work at all:

=IFS(AND(I7<TODAY(),D7<1),"Red",AND(I7=TODAY(),D7<1),"Yellow",AND(I7>TODAY(),D7<1),"Green",D7=1,"Gray")

My Status Definitions:

Gray - Finished

Yellow – At Risk

Green – On Track

Red - Late

 I would like to get the formula to calculate: 

·       If % Complete = 1 then Status is GRAY

·       If Finish Date is less than Today AND % Complete is less than 1, then Status is RED

·       If Finish Date = Today + the next 5 days and % Complete is less than 1, then Status is YELLOW (couldn’t figure out how to add the 5 days)

·       If Finish Date is greater than Today + 5 days and % Complete is less than 1, then Status is GREEN (couldn’t figure out how to exclude the “yellow” days from this formula)

These are the two versions of the formula that I have tried. Neither one works:

=IF(AND([% Complete]7 <

1, Finish7 < TODAY()), "Red", IF(AND([% Complete]7 <

1, Finish7 < TODAY()), "Yellow", IF(AND([% Complete]7 <

1, Finish7 > TODAY()), "Green", IF([% Complete]7 >

1, "Gray,))))

=IF(AND(Finish7 < TODAY()), ([% Complete]7<1), "Red"), (AND(Finish7 = TODAY()), ([% Complete]7<1), "Yellow"), (AND (Finish7 > TODAY()), ISBLANK([% Complete]7), "Green"), IF(([% Complete]7 = 1), "Gray")

Thank you in advance for helping me. I cannot figure this out by myself.