-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Use a form to create a parent row with children rows underneath it
I want to have the form be used to create a row with child rows underneath it, so I don't have to keep doing this manually
-
Using a fillable PDF as a form to fill in Smartsheet
Hello, I am looking for ways to use fillable PDF (attached) as a form to fill out Smartsheet. Similar to how a form is generated in Smartsheet, is there a way for a fillable PDF to be used as a "custom form?" Each field can be defined and mapped beforehand to the corresponding smartsheet and "submit" would update the…
-
Deactivate form after set # of entries/submissions OR by date
It would be a great thing to be able to specify that a form be made inactive after a set # of entries. For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continue…
-
Is there a way to automatically sort by entered form Criteria?
Hi, We have our vendors submitting information through a form. Right now it fills in our sheet in the order it is submitted, with an auto-generated number. One of the input fields they fill out is the location, is there a way to automatically sort and group the similar locations together when submitted?
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Electronic signature in document
I’m having service provide agreements for different clients, how to implement a e-sign workflow in smart sheet where a document is generated and sent for signature to the clients.
-
Generate documents not working
the "generate documents" function is not working, it keeps hanging in the backgound job. Same with trying to download, also keeps hanging. This is accross multiple sheets, the documents are not generated. Anyone who can assist?`
-
Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
Form logic decision based on greater than or less than comparison?
I have a text/number field that I'd like implement some form logic to show another field if the value is 2.0 or greater. I have added number validation, but the logic options don't appear to give me an option for greater or less than. I then thought that I might create a quick formula column that would result in "Yes" or…