Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

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

  • Overachievers Alumni

    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.

    Tomasz Kowalski

    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.

Trending in Smartsheet Basics