-
Report to Sheet
Example I have 10 sheets for each client and converted those into reports to get the information in one place. Now to feed the details like count/avg/pivot/sum on dashboard I should convert the report to sheet. because cannot reference the report to dashboard directly. Will there be anyway to shift the data from reports to…
-
Merged: Dark theme/mode for Report in the Dashboard
This discussion has been merged.
-
User data reports
We've been trying to build some insighful anaylicts for our leaders and I would like to show consumption (views) of dashboards and sheets, but I want to be able to separate internal users from externals. This analytic is a bit manual since when downloading the Activity Log, I'm not able to separate all the internals from…
-
Why do two Smartsheet sheets show same dates differently despite confirming format and timezone?
I've noticed a discrepancy in the displayed dates between two Smartsheet sheets, despite having checked for common reasons like date format, timezone settings, and data entry errors. What other factors should I consider to troubleshoot this issue effectively?"
-
Change in Report Summary Function
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked. For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to…
-
2 views from the same datasets
I'm working within gov trying to create 2 different views from the same datasets. I have a sheet for a given project that includes the staff (in rows) and the number of hours to work on that project for a given week (in columns). I have multiple sheets of this information (for multiple projects). The project view…
-
Row Report Custom Filter: Allow Basic Formulas to used to Filter Data
Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Month =Today(-31) or Percent > AVG([Average1]@row, [Average2]@row) This would reduce the amount of times you would need to…
-
Remove Primary Column From Report
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
Calculate Working days with Multiple If Conditions
I have a scenario to calculate due dates with the following logic. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day I have written the formula like this example - Low 7 days - Request Created On - 04/01/2024 will achieve the output date as 04/07/2024.…
-
Survey Results from Form to Dashboard Chart
Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered…
