Is it possible to show all or selected sheet rows on a form?
I am tasked to show all active rows from a sheet in a Smartsheet form where users can select which one they want to de-activate and provide business reasons and justifications.
Is this possible?
Best Answers
-
There are a few ways to do this.
1) You would need to set up a Data Shuttle workflow to export the column containing the Row ID as an excel doc. You would want to include a filter in the workflow to only pull rows that are active. Then you would need to set up a second Data Shuttle workflow to update the dropdown values in the column where the user can select the Row ID they want to deactivate.
2) You could use a Dynamic View.
3) You can use a report to show only rows that are active and drop that onto a dashboard alongside a form that allows free text for the Row ID they want to deactivate.
-
I personally prefer Dynamic View.
You can use a Web Content widget and drop the form URL in. I would suggest setting the form to automatically refresh after submission.
Answers
-
There are a few ways to do this.
1) You would need to set up a Data Shuttle workflow to export the column containing the Row ID as an excel doc. You would want to include a filter in the workflow to only pull rows that are active. Then you would need to set up a second Data Shuttle workflow to update the dropdown values in the column where the user can select the Row ID they want to deactivate.
2) You could use a Dynamic View.
3) You can use a report to show only rows that are active and drop that onto a dashboard alongside a form that allows free text for the Row ID they want to deactivate.
-
Thank you Paul for these suggestions!
I have used Data Shuttle and Reports/Dashboard, but not Dynamic Views. Based on your options, it seems I'm leaning towards either Dynamic Views or the Dashboard. Just a couple of questions:
- Which one is better for a user point of view - the Dynamic View or Dashboard? (Sorry, I have not seen or used Dynamic Views) For a builder point of view, specially for someone who has not done Dynamic Views?
- If we opt for the Dashboard, is there a way to include a Form on a Dashboard?
- We want to update the sheet with the active rows as well to show de-activation after the whole exercise. Is this easier to do on Dynamic Views or the Form on the Dashboard (Data Mesh possibly to use here)?
-
I personally prefer Dynamic View.
You can use a Web Content widget and drop the form URL in. I would suggest setting the form to automatically refresh after submission.
-
Thank you for the tips. I would look into Dynamic View then.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives