Jason’s Profile

Community member since April 2015

points
191
Company
Smartsheet
Department
Product Development

8

I've read all of the other posts about this formula, including the Blog, but i can't seem to get this formula right.  Here's what I'm trying to do:

 

Due Date TODAY(-5) = Green

Due Date TODAY <4>0 = Yellow

Due Date TODAY+1 = Red

Date Completed = Blue

 

I can get the RYG balls but I can't figure out

3

Looking for assistance. I am looking for a formula that adds the total number of individually RYG in a column that automatically populates a separate cell in a separate column. Any guidance would be appreciated. Thanks. -