Hello! I have been using Smartsheet for a few years but have really only used the basics.
I have a form for our branch managers to submit their monthly safety checklists and wanted to see if there was a way to track / indicate which locations did not submit and for which months. On the form, there is a drop down for them to select the branch location and which month they are submitting for. Then they upload a copy of their signed checklist.
A note - they may not submit their checklist in the same month it is for, so I want to avoid using submission dates. For example, someone might do their January checklist at the end of the month and then not submit it until the beginning of February. That is why I have the dropdown for them to select which month they are uploading for.
We have over 70 locations that are to submit monthly so anything to avoid checking manually would be great.
Thank you!
