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.
Bug?: % Complete report filtering
Is this a Bug? I've set my report to display rows where %complete is "less than 100 or is blank" but the report continues to pull rows that are set to 100. This behaviour seems to be consistent in all my sheets, including this brand new one I created from a template!
Comments
-
I think I figured this out. The report needs to choose items less than 1, since 100% is equal to 1. 50 percent would bt 50/100 or .5, and 25 percent would be 25/100 or .25.
Changed my report to display less than one and is now working.
-
While this is a simple fix why have a column that uses percentages and then logic that uses a 0-1 scale? Very Confusing.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
