Filter Not Showing Results

In a couple of my Smartsheets/Forms, when I try to filter on certain criteria, it's return no data. However, if I just do a "Find" for the same criteria, it locates the information. Has anyone else had an issue where they filter on a column and isn't showing any data but it clearly exists within the column?

Find more posts tagged with

Accepted answers

All comments

Randall Alberts CBRE

Kelly,

I have found to make sure that the condition is to include. I have had team members that are confused at times about the condition to include or not to include. Often times the filter is written to exclude the data that is being requested. A way that I have used to test is to write a filter such as: Site IS equal to "Text". Once this comes up, then I try to further refine to get the results needed.

kelly.strom

Thanks...I'll definitely give this a shot and will offer the suggestion to the other members accessing the data.

billhoskins_apellis

Hi Kelly, The include filter does not locate all results for us but when we use "Find" we find everything.

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.