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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!