RYG Formula and Status Question - almost there
Hi! Below is what I'm trying to solve for:
If the status says Complete, then grey.
If the status says At Risk, or In Progress then calculate the RYG status based on the parameters below.
If the Target End date is 15 or more days from today, it's green.
If the Target End date is 4-14 days from today, it's yellow.
If the Target end date is equal to today, less than 3 days from today or in the past it's red.
I've tried a few different formulas but keep getting an error about incorrect argument set. Please help!