Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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!
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.
