-
Is it possible to escape special characters in dynamically added cell data in request messages?
I would like to build a link to a Smartsheet form from another sheet's workflow, including default values as described here: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values Those default values should be set from a cell using {{ }} as described here:…
-
Report to itemize responses
Hello! I am trying to develop a report that will list out which Residents have selected which Attendings with whom they have worked - here is the sheet that comes from the form I've created - they just click the box for which ones they've worked with. I then want to be able to have a report that lists each Attending with…
-
Double a list of values in a cell
Is there a way to work with a list of values in a single cell? My situation is: a form user enters a submission, that populates a single line in a smartsheet. Each submission may have any number of samples, each which has a value associated it with it. Currently, the form user enters the values on separate lines in the…
-
Can I create one Smartsheet QR code that shows me a list of Forms to choose from?
Currently, my team has several different forms that we use to track process KPIs, or to populate other files. This means we have to post or carry around a handful of QR codes linking to those various forms. I'd much rather have one QR code to rule them all and show all the forms, click on one there and have it navigate me…
-
Snipping and pasting into a form field
Any way to use Windows snipping tool and paste into a form without saving a file?
-
Automated Workflow for Forms and Reports
I created a form to collect data from users (while at the same time protecting my sheet). I need to collect data from users on a monthly bases, and I'd like to be able to send the Form I created at the beginning of every month. I also have a Report that I'd like to send out to managers at the end of each month. I know can…
-
Form with formula INDEX/MATCH
Hello! I'm trying to see if this is possible. I'm creating a calibration form, but I'd like a specific task duration to be tied to each item, which then populates the due date. For example: Each piece of equipment has a set duration (ie. 365 days). This would be hidden on the form sheet. Once a user submits the form, I'd…
-
Form logic in the mobile app
I searched the forum for an answer to this but I could not find one. I started using the new form logic feature recently (great addition!). When I open my form in the app on my Andriod phone the logic does not work but it does work on my iPad. Am I missing something?? I verified my apps are the most recent update.
-
Form questions
Im new to forms. I am trying to setup an "entered date" that defaults to the date the person makes the request and cannot be changed. The date field does not have a "today" button and no information about how this is done. This should be incredibly easy to do...
-
Expense Report Ideas
I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are only paying each person one time for multiple expenses? These people will only attend…
