Best Way to Have a Back-and-Forth with Non-Users?

I have a sheet with info for a few hundred people. For privacy reasons I cannot share it with them, because they cannot view other people's rows (a selectively hidden feature I've put in a vote for).

So I send everyone their information in an update request and ask them to fill it out. I then see their answer, respond, and it sends an update back to them on their data again plus my response.

But sometimes there is a need for more correspondence and we have a whole back and forth. Is there a clean way to do this? The only way I can think of is to have several Q&A columns, for me and for them, where when I ask a question that automatically sends them an update request, and then they answer by filling out the form, and I see it and respond again while at the same time sending them my last answer, etc...

I would even resort to email because that would be much cleaner.

Thanks for any help

Find more posts tagged with

Forms

Sheets

Healthcare

Sharing and Collaboration

Update Requests

Comments

SYSPK

O is there a way for my master sheet to populate into individual sheets for each person? I am not merely looking for reports, but a way for us to enter information back and forth and see it updated on each other's sheets.

Andrée Starå

Hi,

Maybe you could use the native comments instead and have it trigger the update request and maybe also only have it trigger if something else is true.
Yes, it's possible but if it's a good solution depends on your specific needs. Can you share the sheet or some screenshots with more information?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

If you have the correspondence through email, you can save the email to a folder on your computer and then attach that email to a specific row or sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…