Report: Locations that have not submitted a survey
I have a Smartsheet form for locations to submit answers to a survey. Is there a functionality to build a report/listing or some way to showcase which locations have NOT submitted a survey? I assume I would have to reference a complete list of locations to determine if the location is listed in the master data sheet (survey answers sheet). I just don't know what formula or reference to use. Thanks!
Help Article Resources
Check out the Formula Handbook template!