-
Formula to list all projects that asked for additional funding and count number of times
All, I want to do the following, if it is possible, for metrics that I need to include on my Smartsheet dashboard. I have tried variations of =COUNT(DISTINCT(COLLECT without success. Here is what I want to do: In a metrics sheet, I want to go to my "2023 IAP Tracker ELT Approvals" sheet, then automatically list all of the…
-
Smartsheet and Sharepoint Embed Issue
Quick summary: I am no longer able to view embedded Smartsheet items on some Sharepoint Online sites even though I am the owner of said Smartsheet items and I have Full Control access on Sharepoint. I cannot complete the login (see screenshot) as no login window comes up when I click the button. I am reaching out to my…
-
Merged: Dashboard Help - Not able to link a folder
This discussion has been merged.
-
ADVICE ON A USE-CASE: REQUEST FOR PRICING, QUOTE, APPROVAL, PLACE PO, NOTIFY
We need a sheet or maybe Dashboard / Report / Sheets to accomplish this with our customers. It's a current process we do via email, and want to move it to within Smartsheet. Here are the steps, and am seeking advice on the best process: Via a Shared smartsheet (editor-can share, 3rd party outside of our organization), the…
-
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Building a Dashboard from external survey
I'm having trouble organizing either a report or a sheet for it to be data that can be read by the widgets in a dashboard. To recap: I sent out a survey to students who had the choice of attending 3 schools. The first question asks which school they attended, then all the following questions apply to each school. I want…
-
Group widgets in dashboards
When moving widgets around in a dashboard it is increadibly difficult to move the order and placement of widgets. While you can select multiple widgets to move them, you can't group them so that they move together when another widget is being moved near them.
-
Merged: Format Text of Chart Series Labels
This discussion has been merged.
-
Can Entries be Added in to the Calendar App from the Calendar itself? see screenshots
When trying to add an entry via this Panel on the Details panel on the right, it give me the error message shown below that. Every time, even in different sessions, refreshed, restarted, etc. Can this be done? If not, is there a workaround for quick entry right into the Calendar?
