Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Report Criteria Bug?
I have a report that selects rows from several sheets based on a date field being 'today or in the past' and a status (drop list field) being set to OPEN.
For one of the sheets it is including a row with the date in the future. I've tried saving, re-entering and saving in both the report and the original sheet but it still insists on including this one row.
Anyone else had this or know if their is a known bug?
Thanks
Jacky
Comments
-
I have seen something similar when the date is close to midnight and I am not where my computer thinks I am (that is my computer thinks I'm in eastern USA, my Smartsheet settings are setting to central Europe, or some combination of the same)
Did it get self-resolved?
Craig -
Hi Craig,
No, the row is still being selected.
The date column being tested for 'today or in the past' is set to 5th December 2016. The report is sorted by this date column and it is showing the row between 3rd October 2016 and 17th October 2016.
When I first noticed this the previous value in the history was the 10th October; however I've tried changing that and it now has new historic values of 28th November and 5th December but is still displayinng!
The sheet this row is selecting from had other rows that are correctly being omitted or included as appropriate. Within the sheet applying the same filter to the date field also selects the correct rows.
Regards
Jacky
-
That sounds like one for support@smartsheet.com
Hint: To save time, send them a Publish link (edit full) with the first email.
Craig
-
Thanks Craig.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives