Combine "AND and "OR" with filtering

Comments

sburbach ✭✭✭

10/24/24

I am having the same issue!!! Do we know if there will ever be any fix to this? I need this information so I can use this filter in a Dynamic View This would need to be (1 OR 2 AND 3) for this to work for me.

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

10/24/24

@sburbach Try adjusting #3 to be is not one of and select the opposite statuses.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
Report Grouping
Hello All, I am working on a report to sort information by the "sheet name" from multiple sheets. When I use the sort feature to get them ascending the report works properly and lists them all together in sequential order. I then add the "Group By" with "Sheet Name" ascending to get the sheet name to separate into groups…
Rolling 12 month column chart
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…

Help shape the future of Smartsheet.
Share your ideas and feature requests.