-
Automating Update Requests
Having read many posts on the subject, I am guessing there isn't a good answer, but I figured I would try anyway: I am trying set up a recurring task list for process checks in our plant. Every day, each contact has a number of checks to do. I have figured out how to set everything up so that the update requests go out…
-
Calculating a staged reduction in severity
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
-
Less restrictive settings
I am trying to have less restrictive settings to send updates to people who aren't shared to my sheet. The help section suggests that: * Open the sheet and click Alerts & Actions > Manage Alerts & Actions. * Click the Settings icon in the upper right corner of the Alerts & Actions window. However, the last revision of…
-
Column Properties: Not Able to Select Any Standard Option Other Than Check Box
Hi, I have a project queries management smartsheet and one of the Column Titles is "Done". I had chosen "Checkbox" as type of COLUMN PROPERTY. Now I have changed my mind and I want to change the COLUMN PROPERTY from Checkbox to DROP DOWN list. When I right click on Column Heading, I don get EDIT COLUMN PROPERTIES option to…
-
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…
