-
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.
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…