Adding another layer to my report formulas i.e. another way to group the statements

I'm trying to filter a report with multiple levels of filtering, however, I can't seem to find a way to add the last level. I have 4 groups of AND statements bound together by an OR, but I need to add another AND that binds that whole previous statement together. I want Record type is equal to "Opportunity" to apply to all of the AND statements without having to add it into every single one. It works when I add it to each AND statement, but I have multiple duplicates of this report depending on the team member, and if I make changes, I have to update it in 4 places instead of just once on a given report.

(23) Account List - Connor - Smartsheet.com 2023-03-17 14-09-13.png

Find more posts tagged with

Reports

Accepted answers

All comments

Genevieve P.

Hi @g_long23

Since you have multiple criteria in each of your initial AND statements, I would suggest having the Record Type listed in each grouping as you've already done. There isn't a way to create a third-level of filtering like you've drawn.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.