-
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,…
-
Branching Logic in Forms
I need to be able use 11 fields in the logic function of the Forms document. Is there a way to perform this?
-
Display a calculated, non-editable value on a form based on form values
Is there capability to display a calculated, non-editable value in a form? The previous fields are inputs to a conditional formula and I would like to display the results within the form if possible but I can't seem to find a way to do that. Thanks, in advance! Mark
