-
Dynamic View - Creating with a Report
Hi I have a report that I want to have within Dynamic View. In looking at the report, I don't have any filters, grouping, summarization or sorting selected. Below are the steps that I am doing Open Dynamic View Click 'Create View' Select the Report Click 'Create' When I click Create, nothing happens. I have been able to…
-
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023 Just can't get the formula right, keep getting Invalid or Unparsable, I know it should be straight forward but...currently trying to use COUNTIFS I have the formula to count all the values that equal enquiry but can't set it to select between…
-
Merged: Formatting Report Grouping and Summary headers
This discussion has been merged.
-
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!
Having to open each source sheet to have the conditional formatting update is not efficient. The refresh on reports and dashboards do not update the conditional formatting for each row. Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple). I log on…
-
ODBC connector doesn't expose Sheet Summary data
In testing with Tableau, we found that the ODBC connector doesn't expose data from the Sheet Summary reports. That really reduces the usefulness of the Summary for enterprise integration.
-
Filter by Cell Color in Reports
When creating a report from multiple smartsheets, I want the functionality to be able to filter rows by color. This way, if I need the sum of certain rows/parent rows, while excluding others, I can easily do so without duplicating numbers.
-
Make conditional formatting refresh all source pages for report and dashboard accuracy
Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away. Unless I open the source sheet, the reports in dashboards will not update. Even if I press the refresh button on the report or the dashboard, it doesn't actually…
-
Change row report to sheet summary report?
Hello, is it possible to change a row report to a sheet summary report? So that i can keep the same link because i have it linked to on several other dashboards. I'd update the criteria too. Thanks!
-
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?
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.