-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
-
Is there a way to make the form link clickable in google chat notifications from Smartsheet?
Right now, when I send a reminder to fill out a form with the link, it is not clickable (the smartsheet app is, and the email notification is), but, this is odd as for a while I only had my G-chat notifications on for receiving smartsheet updates/notifications, but had to turn on my emails again in order to receive the…
-
Create a Unique Form within Template
Is there a way to link a form within a template that will be associated with the NEW document created by using the template? CONTEXT: Template Purpose: each time site is visited by senior team, a template is created for site visit to document walk-through notes. Form Purpose: individual senior team members would click the…
-
Form Usable on a Template
Would be great if there was a way to create a Form that is linked within a template that when template is used, creates a unique Form so that it translates over to the newly generated document from the template! Otherwise, the form is still stuck linked to the original template and cannot be used on the new document :(
-
Matrix Multiple Choice Grid on Forms
Has the Smartsheet design team thought at all about incorporating a matrix multiple choice grid? (see screenshot below) My team uses Smartsheet forms for almost everything, but will occasionally opt for a Google Form when a matrix grid is the preferred format. The reason for the preference is often because the grid is a…
-
Smartsheet Logic
We have a request tracker that is linked to a request form - each category has a different form and there are questions/fill in options associated with each. Recently, all are now showing on each and/or there are missing items. However, the logics created have not changed. Any reasoning why?
-
How to replace an SOP in a row when that row is updated
Hi everyone! I am creating an SOP Tracking system for my company where I will track all SOP’s being created. That being said, I need to be able to replace an SOP when the SOP is updated. Can I do this using either forms or automation? The SOP will have a specific name associated with it that will be able to be matched when…
-
One form can used twice
Hi group! I have a specific question. I am setting up a new evaluation sheet with the form behind. A sheet contains around 200 columns however in a form is filtered around 50-100 questions to be asked. We will use this form to evaluate internal and external partners. Firstly we would like one person to fill out this form…
-
How to change automation of a form to notify the person who filled out the form whenever a change...
Is there a way to set the automation on a sheet so that the specific person who submits a form, gets an email back when a change has been made to the row? I am trying to create a request for time off form. An employee can submit the form which flags management, then management will select a drop down for approve or deny in…
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…