I'm populating 2 fields for this form and while I can hide them however I need the users to see the consultant name, at least.
I put a notice but I would rather see an alternative way that shows the fields but are just locked.
I hope you're well and safe!
You could add multiple so-called helper columns and show those instead, and then it can't break.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Add the helper columns in main Form sheet or in the Form?
Passing the lock columns from the Form sheet to Form will solve my issue.
You'd add it to the sheet and then to the form, but are you using the URL-query feature to pre-populate the form?
Yes, my form URL is a string query in order to populate the 2 fields however I'm hoping they don't change them as I'm using the exact 2 fields for another formula.
I think Smartsheet will need to give us the option to lock the field in Form.
Hi @maltaee , I too am interested in a feature like this. I don't believe there currently is a way to do this.
The alternative 'solution' is to leverage a "Request update" that is sent to a user via an automation. You can accomplish this somewhat by locking the columns. Locked columns appear as un-editable fields in update forms.
Thanks. The survey form is big so adding more columns to the same sheet will result in a big and long scroll sheet. So far, no one is changing the populated results but it makes sense to have a feature in the form that does not hide the field but keeps visible with no edit ability / locked fields.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.