-
How do you add an email address in a form?
How do I add a hyperlink to an Outlook email address to the description section of a Form? I have tried 'mailto:example@xxxxx.com' but the hyperlink function automatically adds 'http://' in front of the link, leading to a blank page.
-
Reply to a form via email.
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…
-
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…
