Conditional Formatting Dates

jcb8812
jcb8812
edited 12/09/19 in Smartsheet Basics

I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's date. 

The context is that these days are our initial contact date. If we go 7 days without contact (changing the date to the current date) I want the cell to be pink, if we go 14 days from the initial date I want it to turn light red, and if we have gone 30 days without contact I want it to turn dark red. 

Comments