"At Risk" rows not populating my report
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!
Answers
-
@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?
-
This is the formula to flag the row:
=IF(ISDATE([End Date]@row), IF(AND([% Complete]@row < 1, TODAY() > [End Date]@row), 1))
-
@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
-
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
-
Unfortunately that's pretty unlikely. 😅 Sorry
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!