-
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?
-
Save Web Form to mobile Home Screen
OK. So You're going to think I'm crazy but...I CANNOT figure out how to save a webform to my homescreen on my Android phone. I already have several forms on the home screen but I am NOT getting the same options to add the new forms to my Homescreen. WHY?? I have created the web form ON THE DESKTOP computer. I have emailed…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
SUMIFS function
Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, where the following criterias are met: It must say "Ida Skou Andersen" in the column…
-
Selection of form in automated update request
I want to use differnt forms to request task updates, depending on my defined user group. E.g. an external user shall only see basic infomation and update a few fields, internal user shall see all information and update all fields. How can I restrict fields in a form, by user group? How can I select a specific form,…
