-
Is it possible to create a multiline order form?
Good Day Everyone, We have a scenario where we want to automate ordering, currently departments have to manually update an excel form, but it would be extremely beneficial if we could create a Smartsheet form to input this information and to then create the form automatically. I cannot figure out how to create the…
-
Does anyone use SS for satisfaction/ feedback surveys data and reporting?
Out of curiosity, has anyone here heavily used Smartsheet as a tool for customer satisfaction surveys, (bonus points if you use multiple surveys!!), as well as created in depth reports. For instance, what correlates to high/ low customer satisfaction, or just overall performance of a survey? Currently my team is using…
-
HTML functionality to pre-populate forms
I am working on a solution that requires 30 fields (see illustration #1) to be pre-populated with information. The information that is being populated in the fields is also pretty lengthy. I am running into what looks like a character limitation with the final fields (see illustration #2). I have checked the character…
-
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…
-
Can you insert a URL Link into a form
I am wanting to put in a form a URL Link instead of an attachment. Is there a way to do is?
-
Creating unique participant IDs
Hi all, I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a…
-
API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!
-
A way to archive forms?
I have a sheet where I track sign-ups for different types of interactions (different topics, dates, overall purpose, etc.). When I go to the manage forms section, I have to scroll through to find ones created earlier that are still in use (signing up for a consultation vs the forms for signing up for a one-off event). Is…
-
User-selectable "Sticky" Form Response Fields
Allow users to indicate responses as "sticky" so they are prepopulated when the form refreshes. This would be helpful when users need to create groups of multiple form entries where some responses will be the same for each entry within a group, then need to change when starting the next group of entries. In my case, we…
-
How can I apply logic to a few drop downs in a form without having to apply logic to all options?
I am trying to do conditional logic where I have 35 different manufacturing plant locations and 5 of them are Canadian. The first dropdown I have is for them to select a location, and I want to have conditional formatting for the Canadian plants so that when they enter the dollar amount they get the Canadian dollar box. I…