Forms - Can I report on locations that have not completed a form?
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?
Answers
-
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.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn!
Tag my name: @kowal if you need quick response.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives