-
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…
-
Form Logic, Restrictions & Evaluating
I'm building a Form, and one of the criteria is Budget. I would like to evaluate the Budget field as they tab-off of it, before the form is submitted as I know there would be times people will enter an amount that won't be sufficient. The scenario would be - the Budget is $1,000, but based on the number of calendar days, I…
-
Vlookup on sheet using form submission
I am using a form to add a new row to a sheet with each submission. I have a field on the form that the user selects if this is a new contact or previous contact. If it is a previous contact, I want to pull information from another sheet for this contact. To do this I have a Vlookup formula that I was able to get working…
-
Form
We currently have form based on smartsheet, but need to enhance form to show user only records mapped to their username in smartsheet
-
How to block a requestor from also approving his own request?
Good morning SmartSheet Community! We currently have a form for employees to submit Internal Sales Order, in which they must add their functional approver (usually their manager). This request is then sent for approval to 3-4 people/teams. We have an issue with one type of request where the requestor is adding himself as…
-
Summing fields in a web form
I have built a purchase request form to replace a PDF and allow the users to enter details by department and upload attachments. One thing I would like to be able to do is to have the form sum up while being entered - item price + Tax + shipping + other = Total. Each of these are individual fields in the form that a user…
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
Hiding dropdown values on a form
Hi Smartsheet users! I have a sheet for selling fruit to two different customers, which includes a column called, "fruit type" of the dropdown variety. The values it contains are, "apple, banana, pineapple, orange, lemon, mango". Both customers interact with a custom form made for them. Both forms have the "fruit type"…
-
How to auto identify, in sheet, which of multiple forms are submitting row data?
Similar to how the Auto-Number/System Created (Date) auto populates the date the form was submitted. I'm looking for a way to identify the form that added the row data when submitted, so the Originating Form. I thought it was the Auto-Number/System Created By feature, but that just outputted a generic email that doesn't…
-
Stop page refresh when scrolling up within a form opened in a browser on mobile phone
Hi, I want several (non licensed) persons to fill a SmartSheet form via a link in their browser on a Smartphone. With scroll up too far, the page refreshes and all filled data is gone. Hence, I cannot use a form in a browser. Other option, other then licensed users with the SmartSheet app?