RYG Balls associated with Dates

jstotler
jstotler ✭✭
edited 12/09/19 in Smartsheet Basics

I have search and tried multiple expressions and cant seem to get things to work correctly.

I have columns:

Estimated Start Date

Actual Start Date

Estimated Completion

Current Finish Date

Actual Completion Date

 

What I would like is the RYG Ball to be blank for any row that does not contain an [actual start date].

Green if [actual completion] has date populated

Yellow if [Today] is within 5 days of [Estimated completion]

Red if Today is past the [Estimated completion]

 

Any assistance would be greatly appreciated.

 

Comments