-
Multi Line Graph on Dashboard
How do I arrange the data so that I can use the multi-line graph on the dashboard? I have 3 columns for sales (3 weeks out, 1 week out, 1 day prior) and 3 columns for projections (3 weeks out, 1 week out, 1 day prior). I'd like to have the dates on the bottom axis and the # units on the vertical axis and (2 different color…
-
Capture cell changes in automation
Hello, We have an application that tracks users' PTO requests. Sometimes they need to change the date on which they are taking vacation. We have an automation that runs, when a date is changed, to notify their approver to re-approve the request. I can change the message for changes so the approver knows it's for a change…
-
Changes to Webform Access
Have I missed something or has there been a change in the way that Smartsheet webforms are accessed? We use smartsheet forms extensively to gather health. safety and quality information and a lot of this is done by completing a form on a smartphone ot tablet. We distribute the links to the smartforms by text to our users…
-
How I link information together
Hi - I'm new in SmartSheet How do I link information in each other when I do a form??? Plz I need your help
-
Move certain cells to another sheet automatically
Hi, I am trying to create a simple locker tracker. I would like to move the information from the row to a new sheet if the checkbox in the locker revoked section is checked. However, I want to keep the locker # and location of the locker in the primary sheet also. Is something like this possible to automate?
-
How do I set up a QR code to a dashboard and what publishing and permission settings are needed?
We would like to create a dashboard with a policy and possibly other elements like a form. We would like anyone to be able to view the information on the dashboard (so they will be outside our account, may not have a Smartsheet acct/license etc). What publishing/persmission would be needed and how do I generate the QR code?
-
Lock a sheet to archive data
I have a sheet in which we capture each users time on our projects. I will call it the Parent sheet. Each year do a Save As New to start the sheet fresh for the new year. This Parent sheet links to several other sheets that continually change over time. I don't need to track the changes in the linked sheets but I do want…
-
progress percentage cell not accepting formulas
Hi, I have a column to display the percentage of completion for each row, I would like to use something like the below formula in this cell, to automatically update this value, however, Smartsheet is not interpreting this as a formula, instead, is putting a ' sign before the = sign '=IF((Status@row = "Done"), [%…
-
Cell Link inside of a Template
Does anyone know if, or how, we can put a cell link inside of a template?... I'm looking to have all new sheets created with a template automatically have a link back to another sheet. Example... I have a template to start new projects with and I'd like to have another sheet that lists all the projects. So as new projects…
-
Bug: Form editor change from single-select to multi-select does not update the form
Observation - If you have a form with a single-select dropdown and from the form editor change the field type to multi-select, the form does NOT update to allow multiple selection. Workaround - Remove the modified field from the form and re-add it. Limitation of workaround - You must re-create any logic and reset the field…