I'm having trouble with a formula and either my brain is fried or I'm missing something (or both), because I've been staring at it for 45 minutes and can't figure out what's wrong with it.
I'm trying to get a RYGG status column to show: "" or Blank, if no date is entered in Next Deliverable Column, Grey if Disposition Column is "Complete", Red if Next Deliverable Column is greater than Today, Yellow if Next Deliverable Column is within 14 days of Today, and Green, if none of the other criteria are met.
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!