-
Feature request - Headers and footers
I would like to see footers as print options. I know there's already a header in print setup, but I would it to be a little more customizable, such as left, center and right justification and text size. The same customization for footers. Also, a related request is to be able to print a single row in vertical layout with…
-
Alert from webform entry not working
We use a webform to enter new orders into Smartsheet, and need a notification to go out to several team members when one is to be rushed. All team members receive other alerts from changes in that Smartsheet, but this one that needs to be driven from the moment of order entry isn't working. Here's a screenshot of how it is…
-
Rollup Formula
I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it!
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
-
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.…