-
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…
-
Is it possible to have a multiple line entry using a form?
This could be far-fetched, but is there any way to set up a form to where you can fill it out like this screenshot below? Where it is more than 1 line entry without having to enter 100 different submissions? Currently people email me this excel every week and I have to copy and paste it into a different excel sheet.…
-
Showing Pics or Icons for Drop Down Options
This may be a stretch, but I vaguely remember attending a SmartSheet Webinar where the guest customer speaker had drop downs that were actually pictures vs. words. When asked to explain how to create a drop down like that, he showed how he created a "letter type" or "font"(?) that was the picture and then was able to use…
-
Can you create an order form in Smartsheet
I am wanting to create some order form for my company, but i cant seem to be able to create a section where they are able to put in more than one product at a time. What colunm type would i use?