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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!