How can an outside user view & attach a document to rows that only have their email address?
I have a sheet the contains a list of events that my team has approved to be held. Outside event organizers (users not currently shared to the sheet) are required to submit a post-event report to us before they receive reimbursement for their cost to host the event.
I have set up an automated email that asks for their post event report. However, I don't want the report submitted via an email to me. I'd like it to be submitted as an attachment to the column that has their email address in it. I also don't want the outside user to be able to see the other columns on the sheet.
Is there a way to do this? I'm trying to keep all documents in one place and remove the need for me to attach things myself, hence why I'd like them to be able to go in themselves without sharing the whole sheet.
Best Answer
-
Hi @Faith,
You would have to use Automation such as the Update Request.
Reason being that if you give Editor permission to the sheet itself; then in order to be able to allow a user to edit, they will be able to edit all rows regardless of who's name is in a column.
An Update Request can allow for file attachments.
BRgds,
-Ray
Answers
-
Hi @Faith,
You would have to use Automation such as the Update Request.
Reason being that if you give Editor permission to the sheet itself; then in order to be able to allow a user to edit, they will be able to edit all rows regardless of who's name is in a column.
An Update Request can allow for file attachments.
BRgds,
-Ray
-
Thank you! This is exactly what I was looking for.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives