-
Is there a way to arrange data in a Metric Widget?
On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think…
-
User List Report for System Admins - "On Free Plan" column?
I am the System Admin on an Enterprise Plan with user auto provisioning enabled (it was enabled a year ago.) I just noticed that on the User list report generated in the Admin Center, there's a TRUE/FALSE column for "On Free Plan." Out of nearly 500 Enterprise Users, there are 9 unlicensed domain users who show 'TRUE' in…
-
Unable to increase/decrease decimals in Sheet Summary Report (using AVG summary)
In the individual sheets, we are able to decrease the decimal in the summary fields, but when we pull together a bunch of sheets and then use the Summarize feature to get the overall average, we can't control the number of decimals. For example, we have a "Minutes per Case" sheet summary field across a ton of sheets that…
-
Graphs in Dashboard
Hello there, Is there a way to show targets in graphs? For example, I have this sample graph below from Smartsheet. Currently, my goal/target for this data set is shown in blue. However, what I would like is to show it in the following way. The black line is my target. Is this possible? Thanks in advance! Best, Lavanya
-
Is there a glitch in the alert automation when trying to add the double curly brackets?
When creating an alert based on a row being added or changed, I can set the alert to go out hourly, daily, weekly. However, when I add the fields with the double curly brackets, it will not allow me to use the hourly, daily, weekly feature. Is this a glitch in Smartsheet? Has anyone else noticed this?
-
Is there way to add a "save for later" option for forms?
My team is using smartsheet for applications, and I didn't see an option to add a "save for later" button for prospective clients who are filling out the application form. Is this functionality available? Possibly have a link emailed to them that they can click and get back to where they were when they saved? If not, is…
-
Deleting a user
Even if a user is deleted from our SmartSheet account, the contact still appears as an option when adding users to groups, reports, etc. It would be very helpful if there was a way of deleting old contacts completely. Is there a way?
-
Need Confirmation or Correction - Do I understand this correctly.
Background: I created a primary sheet holding unique project information in each row. I then created Summary fields for this sheet data (e.g. Total # of Projects, Submitted Projects, Projects Waiting for Approval, Projects In Process, etc.). I then created Reports for each of those summary fields off the main sheet. I then…
-
Conditional formatting in calendar view
I currently have conditional formatting set up in grid view where the text in a particular column is a certain color depending on the value. Is there a way that this same conditional formatting will apply and be visible when I switch to calendar view? Currently, all the info is the same color when switching from grid view…
-
Looking for Dashboard Help - MTD, QTD, YTD Representation
Hi folks! Looking for help on how to best represent 15 different KPIs on a dashboard(s) with the ability to indicate the period (MTD, QTD, YTD). I realize we can't dynamically filter dashboards so instead of creating multiple dashboards (one for each period), is anyone creatively solving for this? If so, how? Without using…
