-
Creating a survey & collecting feedback for a list of submissions
I've created an intake form and sheet to collect project request submissions, and now need to create a way for the project committee (8 members) to score each submission using a simple 4 value Impact/Effort score that I'd like to present in a Survey Form so I can collect the data and consolidate for presentation on…
-
Dynamic Description using other sheet data.
Is there any option to using dynamic description using {{Column Name}} like we using in Comments in Workflow alert and notification using curly brackets. For Example: I have 40 to 50 Question in the form and I am keeping all question in separate sheet as question bank and linking question using index and match function.…
-
Auto-populate Email field on Form with account email?
My form currently allows non-Smartsheet users to submit a form, so users had to manually enter in their name and email address. We now are enabling the setting to ensure everyone has to login to Smartsheet to access the form. Is there a way to auto-populate the email field on the form to match the account they logged in…
-
Is there a way to auto-generate an MOM (Minutes Of The Meeting) type of sheet/report from your WBS?
I'd like to know if there's anyone here who has tried generating an MOM (minutes of the meeting) directly pulled from your WBS? The intention is for PMs to prevent doing duplicate work, one is updating their WBS, then another sheet or document type for their MOM. Appreciate anyone who can share their experience and best…
-
Elapsed Time from Today
Hi there, I'm trying to write a formula wherein I can track elapsed time since an injury occurred at work. My team would submit daily on a form created and based on the logic I'd like it to parse the data and determine if a 'yes' value is entered then the days elapsed would reset. If a 'no' value is entered then the days…
-
Smartsheet Forms - Show field when (multiple validations)
I have a form where if 3 fields are blank I need a 4th field to be shown and be required. I have logic right now to show the 4th field if the fields are blank, however it's OR logic and I can't see a way to change it to AND. Is this possible and if so, how? (Below is the 4th field and the current logic)
-
CHILD entries from forms
Hi Community Looking at a process to collect information using two forms - the first form collects fundamental information (eg requestor, dept, LM). This form triggers a second (using 'send the user to url option) that collects more detailed, specific information (eg purchase item details for request No.1). This second…
-
Adding a Search Function to a Form to update data in a Sheet
I am new to SmartSheet. We will mostly be using one large sheet with client data. I have a person or 2 that will update information in a row, only updating a small number of fields (columns). Can I create a form that will allow them to open the form, search for a name from the main sheet, choose the right name from a list…
-
Adding a Smartsheet Form to MS Teams
Has anyone discovered a way to just add the actual form from a smartsheet to a tab in a Teams channel? I am looking for a way to have my dept. log and archive certain information that they come across in their day to day work. I felt the best way to do this was by giving them a simple form to copy paste that info into. I…
-
Copy of Form + Responses
Hello, How do I generate a copy of a form + responses from a past submitter? The only option I've seen is to print a PDF from a Smartsheet row. This isn't helpful because in doing this, the questions appear in short form along with the submitter responses. This would not be appropriate to send to a submitter in my…
