Gantt Conditional Formatting


Hello -

I know the basics of conditional formatting, but I can't seem to figure out if SmartSheet can handle the following.

What I'm trying to do is what we can do in Excel - I want to be able to say if TODAY is between Pre Affiliation and Affiliation Date, I want the specific week to be colored blue. If TODAY is between Affiliation Date and Post Affiliation I want it green. Basically so it looks like the below.

I'm assume I'm missing something but I've tried Conditional Formatting but I'm running into an issue where I can't get step 2 only allows me to put specific dates.

I tried added a helper column with the TODAY function but when I try to the formatting of it, it also forces me to put a date instead


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!