"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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!