Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi,
I wondered if anyone can help me with the following web form queries:-
Thanks in advance.
Please see answers below.
No, not automatically but a workaround could be to add it to the Column Description in the sheet if that makes sense.
There are a few different workarounds, but it sounds like it would work better with Update Requests instead. Would that work?
Not in a general form but it's possible to include the information in a link. It sounds more and more that Update Request would be a better solution because then you can include that information.
There are a few different workarounds. I now think that maybe you mean the Update Request feature. Are you? It sounds like that would be better for your needs.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thank Andree, I’ll have a play around with those options, particularly the Update Requests.
On the first one, I was really looking for a way to be able to report the detailed questions in my Forms, in Power BI and, if I use the column description box I’m not sure that is possible.
Happy to help!
Regarding the detailed questions: I would add separate columns for those questions.
Would that work?
Let me know if I can help in any way!
Andrée
Thanks for the reply. I can’t get my head round how I can make it work.
Essentially I want to ask a series of questions which all have Yes / No answers in the form and get about 40 people to respond.
Then I want to report the results of each question in Power BI.
My problem is, I can’t work out how to get the detail of the question into the Smartsheet.
I wonder if I need 1 Smartsheet for the questions and 1 for the answers.
Best Wishes
Hello,
I realize this may be heresy on a Smartsheet forum, but for a survey with complex questions and simple answers (which is what it sounds like you want), Smartsheet may not be the right tool. You might consider a survey tool and then you can import the answers into a tool such as Smartsheet or Power BI, for sharing results.
Smartsheet forms and update requests work pretty well when you have simple questions that can be contained in the column titles, but once the questions get long you reach a limit, as you've pointed out already. Another option is to use one column for the question text and another for people to input the answer (Q1 Text, Q1 Answer). There is a lot of information on the Tableau forums (and I imagine on the Power BI forums) on setting up surveys and survey analysis, although it seems like your data set will be relatively small so you have a fair amount of flexibility on the back end.
Smartsheet does pretty well on graphing in Dashboards, and you can do that upon import of the information. We have incorporated answers to surveys in our other Dashboards when we have things that are important to highlight in a spot people already use for other things.
Jennifer
I'm always happy to help!
How did it go? Did you get something working?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
I have reproduced the following behavior in a validated Smartsheet application. User permission: Editor (not Admin) Row status: Locked (confirmed via row menu displaying "Unlock Row") Text, Date, Contact List, and Checkbox columns cannot be modified. Dropdown List columns remain editable. Selecting a new dropdown value and…
