-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
Create a pre-populated Form with ability to put more than one filed in a row
I am trying to generate a final product where after Person A gets the completed form with the "For Office Use" fields completed. I have written the following (I have x'd out the form ID): "https://app.smartsheet.com/b/form/xxxxxxxxxxxxxxxx?Title%20Company%20Name=" + SUBSTITUTE([Title Company Name]@row, " ", "%20") +…
-
how to get a form on smartsheet to automatically send to a certain manager based on type
In a recent video that was posted by John Cicero, he spoke about having the form automatically update the sheet with which manager that intake request should be submitted to. He used a "Match&Index" formula, although he did not show us the steps on which how he did this. I tried to read the help pages on Smartsheet showing…
-
URL embedded within form
Hi, I'm creating a form and want to include a URL to reference further information available on the web. I have looked in settings and form elements, but do not see if I can include a link?
-
Update Request to external users
Hi all, I am trying to send update requests to individuals who do not have sharing permissions to a sheet. Is there a specific setting I need to turn on? I've published the sheet, so not sure why it doesn't allow the individual to open the request form and edit fields that I've made available for editing. Thanks!
-
Searchable form !
I want to have a search option in my dashboard; where if i put a name it pulls all the information from the sheet and shows in a simple manner. Like in hospital they type in the name and all the information comes up. is it possible in smartsheet? and if so can anyone help me? Thanks in advance!
-
Quick Auto Pop-Up Form As Part of an Automation
We have a sheet where all our RFQ's are entered. I have created an automation where as soon as the Status of the RFQ is changed to Sent it automatically copies the sheet to a Quote Register /Pipeline. I wondered if it was possible that as part of the automation, when the status is changed a quick form pops-up where the…
-
How can I improve the efficiency of my sheet?
We are using a sheet to track a number of different measures which will provide a baseline for Q4 2020. These measures are tracked for a month, with detail and a RAG status being provided by a number of different people once a week from October 9th - 30th. At the moment, we have a separate column for each detail and RAG…
-
Adding a row via a form is acting differently than adding a row directly to the Smartsheet
I have a Smartsheet that is a list of contact dates, with multiple entries per person contacted. There are First Contact rows and Followup Contact rows. I have a form to enter the data. I enter the names into a column that is currently set to a single select drop down, but is not restricted to dropdown values. The column…
-
Printing intake form?
Hello, We are trying to avoid duplication of effort by our team and want to take information that was submitted via a Smartsheet intake form but output it into something besides a row in a spreadsheet. I understand that Smartsheet does not a way to convert a row into a formatted report without the use of 3rd party…