Report showing Item entered Fail, but not Pass

Adam Antonuk

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.

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.