-
Using Contact List Column Type in Task List Forms
I made a recurring task list based on the template Smartsheet provides. I have tasks assigned to different contacts in a contact list column, and users enter new tasks through a webform. My issue comes when they enter the "Assigned To" name. Even if they type their name EXACTLY how it is on their account and in the current…
-
Have User Filing Out Form Include Clickable Hyperlink
Hello, I am trying to see if there is a way to have someone completing a form to be able to include a hyperlink to where a file is. It would then come onto the Smartsheet so someone else could click on the link to get to the file in a shared drive. Many of the files we work with are too large for attachments and a…
-
Contact List not in Alpha order in form
I'm trying to get my contact list in alpha order in the dropdown in form? I can see that this was an issue back in 2017, anyone know if this is resolved? Thanks Renee
-
Selecting only one checkbox
Is there a way to make only allow the user to select one checkbox? If they choose one, the others are unchecked? I have a survey with 5 options (1 checkbox for each). If the user selects #1 but then selects #2, I need #1 to uncheck.
-
Pop up form requiring description
Hi Everyone, I am trying to create a checklist for my organization and have everyone check off on their task by inputting a "yes" or "no" using a drop down list indicating weather the task is completed or not respectively. What I want to happen is, if they answer "no" on the Smartsheet, that there will be a pop up of a…
-
Replacing form attachments
Hi everyone, I am creating a system in which students submit a form for a project that they are presenting to the university. The system calls for constant feedback and re-submitting. The only problem is, I don't see a way to automatically remove their previous file and replace it completely with their new file. This is…
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Question: Can you identify the worksheet behind a form?
The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
-
Updates via webform
I have a business rule list in SharePoint. When updates are needed, the change management process is managed in SS. Currently, the user has to tell us the ID number and name of the business rule manually. Lots of room for error. We would like to be able to pull the ID number from a drop down which then allows the data to…
-
How do I give an outside user access to ONE row of a spreadsheet?
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to inform the editors of anything they need to know about, etc. One of the questions asks them to upload photos they took from…