Report Builder

I have searched but can't find an answer. I am building a report and want to set 'what' as the following:

"is a number

does not contain - total"

However the 'exclude selected items' checkbox only seems to operate for all conditions and I therefore cannot get the desired combination (I can have is not a number and does not contain or I can have is a number and contains total).

Does somebody have a simple workaround for this?

Laura

Find more posts tagged with

Comments

Andrée Starå

Hi Laura,

Which columns/cells is the What criteria looking at?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

If a cell registers as having any text in it, it will not register as a number. You should be able to just set your criteria as being a number, and not worry about specifying to not include specific text.

Sign in to join the conversation!

Quick Links

Trending discussions

Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Time Zones
Hi, I am getting conflicting information from Chat GPT and Copilot on whether I can change the time zone for my system time stamps. I have Pacific time showing up. We are in Eastern Standard Time. I have my setting in my profile set for Eastern Standard time, but it doesn't seem to change the created time stamp and the…
Smartsheet Performance Issue
By when the issue will be resolved?