-
Question on Metric Sheets and COUNTIFS formula
Hello! I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did! Here is my formula: =COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2) And here is my table:
-
How to generate a report for duration (sum hours) to generate a widget.
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number of rows with data entered. Is there a way to generate this data to extract to a widget for a dashboard?
-
Axis customisation on graphs
Anyone else frustrated with auto-generated axis values? For example, when I graph items with <10 entries, there is almost always a decimal place. This doesn't make sense for items like "number of reports". I can't have .25 or .5 of a report. I'd like to see at least a toggle button to whole numbers only. Would love to see…
-
Using cells in a reference for a metric sheet
Hello! I am quite new to smartsheet and had a questions about some widgets. When referring to another sheet in my calculations sheet, I want to refer to a set of cells in a column instead of the entire column. However, I want it to update based on new info entered in the column. Also, anytime the sheet is sorted, it makes…
-
Change Background Color for Multiselect Columns in Metric Widget
Hi there! I'm pretty new to Smartsheet, so wondering about an (apparently) missing feature. I'm aware that in Sheets, multiselect columns options appear in a grey background. The challenge I'm experiencing is that when pulling those values into a dashboard via a Metric Widget, those values appear with a blue-ish/cyan…
-
Count Rows in Reports
Currently there is no way to capture and report the number of rows in a report (or across multiple reports). It is common in dashboard reporting to create a metric (or card visual) to count the number of specific items in a table by simply allowing an application to count the number of unique or distinct rows. For example,…
-
Sheet loading issues - taking too much time to load the sheet
Hi, I have a order intake sheet where I refer the stock quantity from Item master sheet and grant amount from Grant master sheet. I'm doing most of the calculations(like quantity check and cost check) in the order intake sheet. in the particular sheet I have nearly 16 formula columns and multiple sheet referencing due to…
-
Merged: Per-widget background colors
This discussion has been merged.
-
Tracking "Support Type" Across Events
I am attempting to create a dashboard that pulls from reports/sheets I've made that relate to event support for my organization. There are three types of support that my team offers for events. They are not mutually exclusive. The names of each support type are "Streaming," "Podium Support," and "Photography." On the form…
-
Overlapping half doughnut chart
Hello, I'm trying to create a chart that compares two figures to one another using a half doughnut chart. Is it possible to create an overlapping chart using doughnut as a type? Thanks
