Returning Harvey Balls after comparing dates in two columns
Hi SS Community,
I'm trying to return either a red, yellow or green ball after comparing the length of time betweentwo dates.
Here is my example:
I want to say that the lagtime column turns yellow after 2 days or 48 hours if the date it was received and the date it was assigned has reached 48 hours, then red if 3 days or 72 hours has been reached or has passed.
I'll later turn it green if another column turns green based on another formula.
I started using "if and" but started confusing myself.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!