-
Having viables on a form
I have a form that my company uses to enter new jobs on our manufacturing schedule, However we also do a select amount of installs. Is it possible to have the form be able to have a drop down menu (this i know it can) that when The questions is "Is this an install" the user selects "No" then all of the Install questions…
-
Can Barcode Scan return Sheet Data and Auto Complete Form?
Hi! Help!! I'm working on a Sheet to help with our Kanban System. As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate sheet "inventory") then…
-
Formula to display duration of a project
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?
-
Date Formulas
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
-
Help setting up inventory tracking
Im using inventory template. Need a little help setting it up. We receive shipments of doors that we temporarily store in our warehouse. The doors go right back out to job sites, based on installation days. Here's are the processes I would like to design 1. receive shipments. check off that all doors are accounted for. 2.…
-
Send a form once 2 weeks after date shipped
We send samples to our (potential) customers and we want to send a brief update form to the contact in the email to understand the success of the sample. We want this form to be sent once and 2 weeks after the date shipped. I tried investigating notification but I can't limit the notice to send once and on changing dates.…
-
Children function won't work past a certain rownumber
Hi, I am trying to use a sumif >>> =SUMIF(CHILDREN([Sales Stage]30); Status15; CHILDREN([Quotation budget]30)). However for some reason this function wont work passed row 40. Please help. Jesse
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…
-
Card View / Contact List
Hi there:) I have a sheet used as a "Maintenance Request" sheet. It is populated by a form. Each person submitting a request provides their name/email into the "Submitted By" column. This allows them to receive an alert once the job is complete. I have frustration coming from the maint dept. when assigning a job/task…