Reporting
Discussion List
-
Conditional Formatting - ReportIn Using SmartsheetI have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighted red. I've tried to set up a helper co…
-
Centrally managed column values? Multi-project rollup?In Using SmartsheetI'm a SmartSheet noob investigating whether it's possible to recreate in SmartSheet what we've done in Airtable. I'm pretty sure SmartSheet can do what we need, I'm just unclear on how to adapt the flexibility of Airtable to fit SmartSheet…
-
Creating a Burn Down ChartIn Using SmartsheetHello, I'm a bit stuck on how, if it is even possible, to create a burn down chart. I'm importing raw data from Jira (we don't have the plug-in... yet) and we want to show a burn down of our defects backlog, along with optimistic and pess…
-
Creating a Report that ONLY shows rows with AttachmentsIn Using SmartsheetIs there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way…
-
How can I create a Report that pulls data from both rows and the summary of multiple sheets?In Using SmartsheetI am looking to create a Report that consolidates data from multiple projects. I have a sheet for each project which includes Summary fields for each with items like Project Name and Description. I have a single row in each sheet for the d…
-
Can I count data that is saved in a report?In Formulas and FunctionsI have a report that collects data from many sheets and gives me an output and a date. I need to count how many are in that report for a given date. Is there any way to count instances of something occurring in a report rather than a sheet…Answered - Pending Review 15 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Can I make a person an Admin on a report but make them only as an Editor or View on base sheet?In Using SmartsheetI have created multiple reports from a base sheet but do I am wondering if one person can have different access levels to sheet and base sheet. I know they need access to the base sheet in order to view and edit information the report bu…
-
Displaying multiple milestones on a single line in Gantt viewIn Formulas and FunctionsHi there, Is there a way to display multiple milestones, denoted by diamond symbol, on a single line when it Gantt view? It would be useful when tracking multiple projects if there was a way to have a visual overview of key stages in one …Answered - Pending Review 14 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Highlight Changes on DashboardIn Using SmartsheetHello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Report. Anytime there is a new …
-
Dashboard/Report not updatingIn Using SmartsheetWe have a team dashboard that is not showing correct data. It seems that the underlying report is not updating. What is wrong?
