-
Adding Matching Barcodes/SKU's from a transfer sheet onto a master Inventory sheet
Hello all, I'm new to smartsheets and working on setting up a barcode based inventory management system for the warehouse I run. I feel like I have the transfer sheet up and running just need to get all of that information to condense onto my sheet. Would someone be able to point me in the right direction or find what I'm…
-
Why is the mobile app showing me a different form?
Hello everyone, I hope you are having a good Sunday afternoon, I created a form that works very well on computer. On the other hand, when I open the same form on the smartsheet application for a mobile phone, it seems that it does not take into account certain logic that I have programmed. Before opening a ticket with the…
-
Form on mobile view only half visible?
Our form is only half visible when someone tries to fill it out on their phone. Is this a problem with our website or the Smartsheet form?
-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…
-
Generating values that can be referenced in a drop-down
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fills out a form that creates a new line with an auto-generated "Request Number" If the form has a "Build" in the "Request…
-
Display results of a column formula on a form or response.
I have a simple form that allows users to answer yes/no questions with a checkbox. On the SS I have a formula column which sums the count of the yes answers and gives a score. I would like the users to see that score on the form either as they fill it out, or once they submit in the confirmation message or in the email…
-
Contacts in a Form
Hi I'm working on a submission form but, I'm struggling with the contact columns. The use case is that a file review will be done on any one of over a 1,000 lawyers the compliance officer completing the file review needs to enter the lawyer and their supervisors name in the form so, that reminders can be sent to complete…
-
How to embed a calendar to a Form
Hi , We are using Smartsheet form to sign up for move pack appointments. How can I embed a calendar into a sign up form? I have 9 days and 6 timeslots each day. I am using CountIF formula to alert when a cap of 9 sign-ups reached. I am trying to find a better way to manage an hourly sign-up capacity. If I can show the sign…
-
Form Response Validation
How can I validate the format of responses? For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format. Also, is there any way to validate an email address?
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
