Jason’s Profile

Community member since April 2015

points
191
Company
Smartsheet
Department
Product Development

1

Title says most of it, so I'll repeat it:

Bug or Feature?: Used in Formula does not display for Contact List

Hover over the [ContactList] column which is referenced by formula on the destination sheet does not ever display the "Used in Formula ... " pop-up.

I did not see anything in the Help

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