Anonymise form submission

Hi,

I have a form which fills a sheet with an "Anonymise" checkbox column and a "Submitter" text box column. (staff feedback form)

I'm trying to give form submitters the option to anonymise their submissions. At the moment, an individual has their own link which will auto-populate the submitter on the form but want to be able to change that value to blank if the anonymise checkbox is selected.

I don't want to make this a dropdown (as then a submitter could respond under another person's name).

Can I use a formula to make the Submitter field become blank at the time of submission if the 'anonymise' checkbox has been checked?

Or is there a better way to do this?

Thank you,

Find more posts tagged with

Sheets

Formulas

Comments

Andrée Starå

Hi,

You could use a copy of the form that doesn't require the submitter to be logged in.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Unfortunately EXACTLY what you want isn't possible. Andree's suggestion is a good one. The only other thing I can think of is to use conditional formatting to change the font and background of the name column to white if the box is checked. The name will still be there, but it will be "hidden".

balloonhead

Hi,

update in case anyone else is looking for a solution to the same problem

I have given each individual a link (actually QR code and NFC on a card customised for each individual) which has the form URL encoded onto it with ?Submitter=Firstname%20LastName on the end

The Submitter column is a dropdown with only one option - Anonymous

This way when they navigate to the page via the QR / NFC they will get the dropdown with two options - their name and anonymous

Obviously not very hard to spoof another name into this but given the target group I am involved with that's not likely to be a problem

Thanks for your input!

Andrée Starå

Happy to help!

Nice workaround.

J. Craig Williams

Check this out for default values in the Smartsheet Forms:

http://ronin-global.com/2018/07/20/defaulting-to-a-date-in-a-smartsheet-webform/

I'll add your user story to my use cases for this.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…