-
Rank Pivot Results WITHOUT DUPLICATES
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM 💲 Total Rental $ Amount {H}" respective to each listed equipment type, in column "⚠️Cat-Class Description". I'd like to rank…
-
Business plan. Limitations on the number of dashboard widgets. No access to Team workload tracking
Good afternoon. I am a license holder by invitation to the work team of our company under the Business tariff. Why the license holder has a restriction on the number of widgets on the motherboard, if the business plan does not have these restrictions, and the restrictive message says “upgrade to Business or Corporate”?.…
-
How do I get a date value to show/change in a dashboard?
I have inherited and existing Smartsheet, which I am just learning. The dashboard has a metric widget with a week of, but it does not change we are stuck on one week. I have a column that is now labeled as "Week Of" the cells show the date as 07/28/24 and the column type has been changed to date. How do I go about setting…
-
Dynamic Forms created as an Object
It would be great to have forms created as objects, that way if I copy paste a folder, or am provisioning projects via control center, the form URL will be dynamic to the newly created object instead of me copy/pasting/modifying dashboard links etc.
-
Gantt View on Dashboard not starting at today's date
Hello! I have a report that summarizes deliverables from several sheets, with the information displayed in a Gantt view. On the Gantt Timescale Settings, the checkbox to open the view to today's date is checked. I created a dashboard and have the report on it with the Report Widget. When I load the dashboard, it properly…
-
Can't create pie chart of action statuses
Hello community, I am trying to create a pie chart for an operations plan dashboard. The pie chart is to visually represent the status of each operational task in the plan grid. The 'Status' column in my grid contains cells which contain dropdown options of "Not Started", "In Progress/On Schedule", "In Progress/Behind…
-
Dashboard Templates
I designed a dashboard to capture our department's customer communication. There is a form that populates our communication log, reports and feeder sheets that breakdown each team members' bucket of logged calls, and a bar graph categorizing the types of calls. I'd like to have a clean sheet/reports for our Annual Report…
-
Sort Chart Data in Dashboards (Ascending or Descending or Alphanumeric Order)
Please add a feature that lets you sort your chart data in ascending order (e.g., 1, 2, 3, 4), descending order (e.g., 4, 3, 2, 1) or alphanumeric order (e.g., 1, 2, 3, a, b, c).
-
Remove empty space at bottom of dashboard after consolidating empty space
When working with dashboards, if you remove or change widgets, it can leave empty space between the widgets. To remove the empty space between widgets, you can use the "consolidate space" option under Edit. However, these just moves all the empty space to the bottom of the dashboard. So if you need to send the dashboard in…
-
Looking for a consultant to help build intranet/dashboard & basic CRM.
Hello, I am looking for a Smartsheet expert who can help us build a custom dashboard for internal and external use. We are based in Los Angeles, but most of our team works remotely. So are you / or do you know an English speaking Smartsheet expert, who we can hire for support and who has time the coming month? Thank you,…
