-
Progress bar on Smartsheet Form?
Does anyone know of a way to add a progress bar to a Smartsheet Form? I.e., as the user completes the form fields, the progress bar shows how close they are to completing the form? Thanks for your help! :)
-
Best way to structure an equipment maintenance form
I am setting up smartsheet to track maintenance on our heavy equipment. I would like to have a form that the technicians fill out when they perform maintenance on a machine that is specific to that machine. I have created a sheet for each piece machine, and in that sheet I have each task as a column with the part number in…
-
Confirmation Email Logo Quality
I've added a custom logo using the dimensions recommended for forms (300px x 52px). I found the quality wasn't good enough so I saved it slightly larger and it looks great in the form itself. However, when the requestor selects "Send me a copy of my responses" and receives that email - the quality of the logo is…
-
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…
