Gantt Conditional Formatting
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
Check out the Formula Handbook template!