-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
-
Dashboard chart from a report
I have a report which collects data from multiple sheets - this includes project health using RYG status. I would like to add a pie chart to reflect project health on the dashboard using the collected data on the report and it's giving me "The selected columns cannot be charted". Is there a way around this?
-
How to create a report that summarizes various dates as monthly totals?
I have a Project Tracker sheet where we keep track of all our projects, their status, if it's been invoiced, and the date of the invoice. In Excel and Google Sheets, we can easily create PivotTables to summarize all the dates of the projects marked as 'invoiced' by month, so we can see the the monthly and annual invoiced…
-
Column Descriptions
How do I get the column Description to flow from a Table to a report?
-
Grouping Reports
Hi, I have two sheets I'm putting into a report. They have different primary columns. I wanted to group by the first sheet's primary column and pull in additional information for the second sheet that has been matching and no matching column headers. But when I pick primary in group, it will only use the second sheets'…
-
How to build Charts from Reports
I am curious if anyone is aware of any documentation on building charts from reports. I am actively learning as I go, but I notice that sometimes a report format works for building a chart and other times I get an error that the data cannot be charted. Is there documentation or best practices on the report format you need…
-
Formula Needed For Combining Rows with Exact Values in Separate Sheet
Hello Smartsheet Community, I have a compliance tracker sheet that captures employee's HIPAA and FEMA certifications. I have been tasked with creating a dynamic view for their immediate supervisors. I have two separate views for FEMA and then HIPPA. However, I also have employees who have submitted separate reports for…
-
Moving value labels on stacked graph
Is there any way to change the location of the labels on a stacked graph? They appear to the right of the bar and with multiple items in the stack, it is misleading as to what the label represents. See below - the 4th item down in grey represents 60% but the 60% label is on the yellow bar. We want the graph to look like…
