Automate RYG ball with criteria criteria pivoting around due date.

Jon Stikka
Jon Stikka ✭✭✭
edited 12/09/19 in Smartsheet Basics

trying to figure out automation formula for the status balls based on the following...

  • Done check box ticked - BLUE
  • Open Tasks - GREEN
  • Caution - YELLOW (week before and week after the due date)
  • Overdue - RED (more than week after the Due date)

It's the yellow I am struggling with. Do I need to create an additional column to count an absolute value +/- away from the due date?