-
Where are company generated emails stored or pulled from?
Where does SmartSheet pull our company email addresses from? We have a situation where an employee who is no longer with us has the same email address as another active employee. When our active employee submits a form in SmartSheet, the incorrect email address associated with the former employee is being used to send an…
-
Can you reply to the email you receive after filling in a form?
After filling out a form, you have an option at the bottom of the form to email a copy of this to yourself. Once receiving the email copy, are you able to reply to that email and have the response become a comment in that line on smartsheet? I know you can reply to emails on smartsheet and have the response become a…
-
Conditioning logic to be AND not OR in form
Hi there, I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR. Question 1 : A, B or C Question 2: X, Y or Z Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it…
-
Autopopulating Dates on a Sign-up Sheet
Hello, Does anyone know if there is an option to auto populate dates for a sign-up sheeting on SmartSheet? For example, I have sessions that individuals are allowed to select from October to December. However, I do not want those dates to show up after they have passed. So, if today is 10/4, then I do not want my sessions…
-
Requestor carry over: Form pointing to another form
I have set up an initial intake form which gives the choice to go to another form: one form or the other depends what they want, e.g. request a report or request access to a file. With either form, the filled out request goes to the same smartsheet that captures the request regardless which form they use under the column…
-
Using forms and multiple rows
Hello, I have created a form for my team to enter data to populate on a master sheet. We will have multiple part#'s and QTY's per request, however, I cannot find a way to have forms split those into separate rows. Is there a way to have a form submission separate by line in the form to a separate row in the sheet?
-
How to subtract quantities from one sheet via forms to another sheet with total quantities
My issue is this: I have a master sheet with material types (A1,A2,A3 etc..) and total material quantities (#'s). The other sheet I am using is updated via forms. The form is used for distributing materials and requires a material type, and material quantity before submission. Once submitted I would like the quantity to be…
-
How to cascade the same grouping of rows multiple times for device management in a form
If I have a row that says "how many devices do you have?" And a user inputs 6 (for example). I would want the form to present the same grouping of three rows (serial number, location, owner), six times. That way each device has a unique place to document these discrete items and they file back to the same column in the…
-
Allow form users to create individual templates of the form for repeat use
We use an intake form for users to provide order instructions. We offer the user the opportunity to get a copy of their responses. Please provide a way for them to save the form with their standard information so that when they need to submit a new order, they do not need to re-enter all the standard data. It could be an…
-
Form Entry Mystery! Validation Failure...
I am trying to figure out how a form user was able to enter alpha characters into a form field restricted to numbers only. The form settings were last updated on 9/14. When I checked the form settings after the text entry was made, the field was set to "Number only" validation. I have tried to replicate this, but I cannot.…
