Automated rules for lines do not transfer into reports

Hi Community!

I have created a report in Smartsheet that shows me all my open tasks across all sheets. If the date on a sheet is in the past, the corresponding line turns RED. Unfortunately, this is not automatically carried over into the report. Is there a common mistake i made?