-
Pivot Add-on for Smartsheet
Anyone using the Pivot Add-on for Smartsheet. Wondering: If you use it to build a report/cube for your master sheet can you query it to get summary information rather than build a whole lot of summary fields to reference in dashboard widgets. Is there a dashboard widget for a report created in Pivot to show the actual…
-
formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
-
Report Doesn't update status from sheets
I have a report pulling status from different project sheets and notice that the Status (R, Y, G) does not automatically update in the report. I have to open and close each underlying sheet for the status in the report to be updated. My report is pulling information from 100+ sheets. The status column in each sheets uses…
-
Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
Sheet Summary fields not showing all data on Report
Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works. Why are the green showing just fine…
-
Conversations in Reports
I currently use reports tied to a central tracker to report out project updates to several different teams. Some of these projects require sharing of attachments and conversations about those attachments using the row's conversation tool. When individuals are tagged in these, the auto-email to their account links to the…
-
Add the ability to enter simple formulas into cells in a Report View
I've got a Report View that simplifies what columns & rows are displayed out of the full sheet so that a user can input data on a weekly basis. We recently are facing a scenario where we need to sum up multiple values into a single cell. Although the math isn't 'hard' it is more efficient to simply type in i.e., '=123+456'…
-
Merged: Need Ability to Print Collapsed Reports
This discussion has been merged.
-
Custom Columns in 'Sheet Summary' Report
This report is amazing and could be super useful if we have the ability to customize the column names according to our team's/organization's needs. The columns in the 'Sheet Summary' report get auto-generated and are not based on the source sheet(s). We need to be able to customize these as my team uses different legends…
-
Count from all project sheets in the same Workspace
We have multiple projects (25+) using the same template in a workspace. I am able to create a report that shows all of the upcoming task by adding the entire workspace to the report and creating the right filters. I want to output a count of all of these tasks and use that value in a dashboard setting. Smartsheet does not…
