"At Risk" rows not populating my report

deb_63_hydracor

Hello,

I have a report that all sheets (deployment plans) in a workspace feed into. The flagged items don't appear on the report until days after the row is flagged. Or they suddenly appear on the sheet itself (and then subsequently on the report) but only when I open up the sheet.

It's a little hard to explain so let me know if you need clarification.

Thanks!

Samuel Mueller

@deb_63_hydracor I have a follow up question. Are you using a filter based on date, and is that date determined with a "Today()" formula?

deb_63_hydracor

This is the formula to flag the row:

=IF(ISDATE([End Date]@row), IF(AND([% Complete]@row < 1, TODAY() > [End Date]@row), 1))

Samuel Mueller

@deb_63_hydracor That is the reason you are having issues. The "Today()" formula will only update when a sheet is opened and saved, like you are experiencing. Follow this help guide to create a today formula that will update every day on its own.

Automatically update the TODAY function in formulas | Smartsheet Learning Center

deb_63_hydracor

This is great, thanks! I use a template from which to create deployment plans. I don't suppose there's a way to update already-created plans collectively, is there? I'm not expecting a "yes" here. lol

Samuel Mueller

Unfortunately that's pretty unlikely. 😅 Sorry