Forms - Can I report on locations that have not completed a form?

Matthew Crum

We are using forms to have team members fill out a "visit report" each time they visit a location. I have a field for location name, visit date, month, etc. Can I create a report that indicates which locations have NOT had visit report completed by month?

kowal

hi @Matthew Crum,

The reports are used always to add new Rows - in that case also also new destinations. If you do have some other data to compare it will be impossible to show "what was not added to the sheet".

If you have some comparison data in different sheet like for:Destination 1, Desination 2, Destination 3 was planned to view but there will be no data about those destinations provided by your team members you can create report and it will show: BLANK next to Desination 1 eg. and you will know it was not visited.

hope it helps.