-
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…
-
Nested Or within Countifs formula
Hi, I am hoping to see if I can get help with the following formula: =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms") Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not…
-
Formula to Roll Up Task Status
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Parent shows as Not Started if: All children are either Cancelled or Not Started. Parent shows as In Progress if: Even one child…
-
Report from 2 sheets shows same column header twice and doesn't combine
I have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it doesn't do this with any other duplicate columns, which is extra weird.) Instead, both columns are next to one another and…
-
Grouping dates in reports not working as expected
We have started using the grouping function within several reports and grouping on a date field but we are coming across tasks with the same dates not appearing within the same grouping? We are not grouping by any other column and the formatting of all dates across all sheets is the same? Has anyone else discovered this?…