prepopulating a form
Hi Smarsheet Community,
We need your help PLEASE! We have a master sheet and created a form to send to each line within the master sheet, asking them to answer additional questions. Is it possible to show some of the data in certain columns as a summary or reference for the individual updating the additional information?
Answers
-
Hi @cllteran
Short answer No. A form is a one way window to a sheet - it will not allow users to see gathered data. But. Two parts to your question. "Is it possible to show some of the data in certain columns" Yes, by using conditional logic.
"As a summary or reference for the individual updating the additional information" If the form was accessed as a link on a Dashboard & that Dashboard had a chart of the sheets data? then Yes. As users submitted the form data from the sheet would be reflected by a chart on the dashboard.
Hope this helps
Cheers.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives