-
How to embed HTML hyperlink into form submission email
Hi! I love Smartsheet but I can't seem to find a way to do the following: After a user submits a Smartsheet web form entry to populate my sheet with data, I'd like to embed a hyperlink into both (if possible) the response and email confirmation so that the user is directed to a web page on my site for next…
-
Is there a way to duplicate a line with slight modifications to one cell?
I'm trying to find a way to duplicate a line based on data from another cell. For example, if I have a line that includes A, B, C, and/or D in a list in one cell, I'd like to make duplicate lines where the Primary column name is changed to {Primary column} - A/B/C/D, while all other data from other columns is preserved.…
-
How to add columns based on user input from another column?
I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if the user inputs 4 in the Number of Children field, I want a Name, Age, and Gender…
-
Some users' form submissions don't add data
Form is submitted successfully, but new row does not show up. form submission works 100% of the time for some users. Other users it works 0% of the time, including the sheet owner. Any ideas?
-
Forms - can someone completing a Form save this as WIP, and come back later to complete?
We have lengthy Forms and it would help if these can be saved as WIP so that someone who completes a Form can save in draft format and then come back to complete this at a later date?
-
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…
-
Can I restrict dropdown options on a form?
I have a sheet that is used for tracking external project requests as well as internal projects. These are acquisition-related projects that only my team logs. As such, I want my Request Type dropdown on form submission to exclude these two internal items. How can I do that?
-
Can you capture elapsed time completing a Smartsheet form?
When you use the Forms Application in Excel the output does a date/time stamp. i.e. adding the Start and Completion Time columns along with the submitted data, thereby (in theory) capturing the elapsed time the user spent completing the form. Does Smartsheet have this capability ?
-
Can you add an approval or action button directly to a notification?
Hello - I am new to Actions and Alerts. I would like to set up a workflow to allow our team to submit travel requests for their managers for approval. I have my form and sheet set up fine, and the workflow seems to be working correctly and notifying the indicated approver via e-mail. However, it looks like the approver…
-
How to share my form with my team without permitting them to edit the underlying form?
Hello, My team is new to smartsheet and i've created some forms and a dashboard. I've already shared with my team the workspace. I'm trying to figure out how they can fill a form i've created and save it in their folder without changing the original form.
