if and blank
I have a date that a survey was completed and a date that someone has contacted a customer and I'm looking to create a formula that highlights if the response date was over 3 days ago AND there has not been a successful call (the contact date column will be blank) then mark this as red, if the response data was over 3 days ago and there has been a successful call (the contact date column will have a date) mark it as green.
I have tried:
=IF(AND([Survey Response Date]@row >TODAY(+3) , [Successful Contact Date]@row = ""), "Red", "Green")
Help Article Resources
Check out the Formula Handbook template!