Automate RYGB Balls

Shannon Heward

I'm trying to automate RYGB balls by Date Needed [date] and Completed [checkbox] fields.

Blue - Completed field is checked.

Green - Up to 3 Days after Date Needed

Yellow - 4-5 Days after Dated Needed

Red - 6 Days after Date Needed

Could you please assist? Thank you.

Paul Newcome

Try something like this...

=IF(Completed@row = 1, "Blue", IF(TODAY() <= [Date Needed]@row + 3, "Green", IF(TODAY() <= [Date Needed]@row + 5, "Yellow", "Red")))

Shannon Heward

Thank you, Paul. This is PERFECT! I greatly appreciate your help!

Paul Newcome

Try something like this...

=IF(Completed@row = 1, "Blue", IF(TODAY() <= [Date Needed]@row + 3, "Green", IF(TODAY() <= [Date Needed]@row + 5, "Yellow", "Red")))

Shannon Heward

Thank you, Paul. This is PERFECT! I greatly appreciate your help!

Paul Newcome

Happy to help! 👍️