Conditional Formatting Calendar Tasks Excluding Parent

Options

Hello,

I was hoping someone can help me figure out why my conditional formatting conditions are not formatting parent rows.

In the attached example, my conditional formatting will highlight the task bar a color if "Level = date range" and "Dates Confirmed = Green".

When I change to "Calendar View" I notice rows 65, 68, and 272 do not take to the formatting. The only difference I noticed between calendar entries that appear with the formatting is that they aren't parent rows


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!