Report showing Item entered Fail, but not Pass

Hello all, First time posting here.

I'm using forms to populate sheets with data on quality inspections processed. I'm looking for a way to create an ongoing, active report of units (which are identified uniquely with a serial number) that are awaiting fixes. Currently I submit a form for the initial "Fail", then submit a second form for the "Pass", and I want to be able to have a report that simply includes SN's (and other data in the row) that have a "Fail" entry but NOT a "Pass" entry.

I hope that I explained that well enough, Thanks in advance for any and all help.

Find more posts tagged with

Forms

Sheets

Reports

Sheet Summary

Workflows in Smartsheet

Accepted answers

All comments

Yvonne Smythe

Hello and welcome @Adam Antonuk. I hope all is well with you. Have you tried creating a report using the sheet and creating a filter on the report for the status column? Any new line items on the sheet with a 'fail' status will automatically be pulled into the report based on the relationship of sheet and filter. Hope this is helpful.

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.