Returning Harvey Balls after comparing dates in two columns

Tabitha W.

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!

Nic Larsen

=IF([Received by AA]@row - [Assigned To OSU]@row >= 3, "Red", "Yellow")