RYG Date and multi columns
I am working on a display for RYG indicators where my data collection sheet will look at today's date, a site that has either confirmed a check, failed one or has not performed it yet. I have pieced this together from some of the terrific responses found here but I keep getting that unparseble error. The columns light up like they are being referenced properly but all I get is the error. Any assistance is appreciated.
=IF(AND(DATEONLY(Created:Created) = TODAY(), IF(Site:Site "Phoenix", IF(Checkout:Checkout "Yes","Green", "Yellow"),"Red")
Help Article Resources
Check out the Formula Handbook template!