Conditional Formatting

Bert Hoffbeck
Bert Hoffbeck โœญโœญโœญโœญ

I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions.

As an example: I want to show the date cell to show green if it is a future date with a Green Background UNLESS it is within 90 Days of Today's date. If that is the case, I want to show the background as Yellow.

Any suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!