-
How to Pre-Populate a Field in a Form?
Hello Smartsheet Community, I am trying to pre-populate my Work Order ID field in a form with the number it is assigned in its row. A while back, we were given a complex formula to include specific fields but it is very complex and hard to understand. Can someone please let me know how to add the Work Order ID to the form…
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Generate Bar Code and link to cells
can we generate barcodes of each equipment and with the help of bar code scanner, can it display the information of it with the the options to update the forms? I know we can update the forms but how can we display the informations from the sheet at the same time?
-
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…