Automation for Reports
My department currently has 2 Smartsheets and 1 report for processing requests from external users. These sheets are not public, and the governing bodies are against making them public due to internal conversations documented on the sheets.
We would GREATLY benefit from automation in this process, but the requirement to keep the sheets private is a huge hindrance. We have to communicate with these external users, but currently, it is by email which is tedious and causes requests to fall through the cracks. My only idea, outside of creating another Smarthsheet, is to create a report, make it public and add automation to the report (i.e. reaching out to the submitter and notifying them that their request has been approved, denied, needs clarification, etc). However, I see that it is not possible to have automation in reports. I am posing the question: does anyone have any tips/tricks/suggestions for the above topic? I've been wracking my brain for months. Also, would anyone mind explaining why reports do not have automation and if this could be added?
Thank you for your time,