-
Can you add an email address via the Link option in a header field on a form?
I want to add verbiage, a name and email address in a header field at the top of my form. I enter the email address, highlight it and click the link option and it's pasted in there. It shows underlined but when I preview the form and click the link, it takes me to my company page (for example, cbre.com and not my email…
-
Looking for VLOOKUP formula to pull data from mulitple sheets
Hi all! I am attempting to use a VLOOKUP formula to pull data across multiple sheets. Since Smartsheet does not have the capability (yet, I hope!) to merge multiple form submissions onto one row, I am creating 2 other data collection sheets and need to pull that data to my master sheet. Each sheet has a unique reference…
-
URL Query String and Workapps
Hi, I created URL query string to pre-populate values a form for 12 different departments (to ensure each selects their correct area). I followed the instructions from Use a URL query string to prefill different default values for the same form | Smartsheet Learning Center. Then I tested each URL strings to ensure the…
-
Form Naming Conventions
Similarly, to how we can use the {{}} brackets to enhance the subject line of an automation, being able to include this in naming forms would save a lot of headache and manual effort. Currently, we have to manually rename each form as sheets are created to match their project naming conventions. If we could use the bracket…
-
Contact List Field in the New Logical Forms
I have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the contact field nothing is populating from my imported contact list, what am I missing?
-
Web Form - Customize deactivated message?
Hello! I am using a web form to have people submit nominations for an award. The submission process has a due date so I will need to disable the webform at a certain point. Is it possible to customize the "deactivated" message from Smartsheet? Thank you!
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Filter options not showing
Hi all, I am trying to create a filter to only show one selection from a drop down list. When I begin to create the filter and go to select which option I'd like to filter, it's not there. The option shows up on the form and in the Smartsheet but does not show as an option when I try to add it to a filter. Any suggestions?…
-
Changing File Directory for downloaded attachments
Hi all, For context, I use a Form to manage incoming service requests and generate PDF Work Order attachments. I would like to change the file directory for downloaded attachments to a shared folder rather than 'Downloads' so my supplier has visibility of the work orders when they are assigned. I can't seem to find an…
-
Can I add an import template for the user to download and then import before they submit the form?
