-
How do I have a count of items on a report on my dashboard without a metrics sheet?
I have a dashboard that displays a few reports on it, with the list of items in those reports. At the top of my dashboard, I would like to simply have a count of how many items are in the reports listed below it. I currently have separate metrics sheet that calculates this, but I find that the count of items the metrics…
-
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
-
Report Editing
How do I change the font size, color, etc.. on a report to make it look nice?
-
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…
-
Control Center-Generated Report Issue
Hi - curious if anyone else has ever come across this - not sure if it's an issue or if it's something in the configuration that I am doing wrong. We have a control center solution that uses Dynamic Report scope to add the reports for newly provisioned items into a blueprint-level summary report. We have them grouped by…
-
Freeze columns in a report on a dashboard
If a column is frozen on a report and that report is used in a dashboard, it would be helpful for that freeze to apply when viewing the report on a dashboard.
-
Conditional Formatting in a Report
Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
Why can't I filter a report that is shared in a Work App?
I have created a report and shared it in a Work App (Using editor settings). Yet when I preview the report, I cannot use the filter function for this report. Can someone help me out to figure why this is occurring?
-
Generating Automatic Monthly report
Hello, I want to generate a report for for the sum of a dollar value received in a month across various business units. for example: in February, McDonalds 1 credited $800, McDonalds 2 $300, Mcdonalds 4 $500, and so on. I have a helper column already for when the line was closed and a separate column for the dollar amount…