Reporting

Ask a Question

Scrolling a dashboard inside an iFrame on iPhone - not workingAnswered Question

Answered Dan Snodgrass 28 views 2 comments 0 points Most recent by Dan Snodgrass 03/27/20Using Smartsheet

First post 03/24/20,Last post 03/27/20
Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
Using Smartsheet282
Dan Snodgrass
Reporting on who and how many times an individual has attended eventsAnswered Question

Answered Melissa P-B 42 views 19 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/12/20,Last post 03/27/20
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions4219
Melissa P-B
Planning Calendar conundrums

Mary Vogt 40 views 14 comments 0 points Most recent by Mary Vogt 03/26/20Using Smartsheet

First post 10/21/19,Last post 03/26/20
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet4014
Mary Vogt
Automatic report creation with custom templateAnswered Question

Answered Jefferson Ribeiro 20 views 2 comments 0 points Most recent by Jefferson Ribeiro 03/25/20Using Smartsheet

First post 03/25/20,Last post 03/25/20
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. https://us.v-cdn.net/6031209/uploads/781/KSSZYBE6N9EB.png https://us.v-cdn.net/6031209/uploads/547/MXTN397LY9XS.png For each new answer on the form…
Using Smartsheet202
Jefferson Ribeiro
Datamesh - way to transfer only parent row to sheet?Answered Question

Answered KellyAnne Brophy 22 views 1 comment 0 points Most recent by Nathan Lloyd 03/25/20Premium Apps and Integrations

First post 03/18/20,Last post 03/25/20
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each r…
Premium Apps and Integrations221
KellyAnne Brophy
Link Data in a Smartsheet on a Specific Day and Make StaticAnswered Question

Answered Donna T 8 views 2 comments 0 points Most recent by Donna T 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…
Formulas and Functions82
Donna T
Nested if for FLAG columnAccepted Answer

Accepted Answer Daniel Child 23 views 2 comments 0 points Most recent by Andrée Starå 03/25/20Formulas and Functions

First post 03/24/20,Last post 03/25/20
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
Formulas and Functions232
Daniel Child
Can Formulas Reference Reports?

UnaB 274 views 11 comments 0 points Most recent by Paul Newcome 03/23/20Formulas and Functions

First post 11/20/18,Last post 03/23/20
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions27411
UnaB
Combining data from 2 sheetsAnswered Question

Answered [email protected] 19 views 4 comments 0 points Most recent by Paul Newcome 03/23/20Using Smartsheet

First post 03/20/20,Last post 03/23/20
Hi I have created 2 sheets: Employee Onboarding Employee KRAs Both the above sheets have one common field: Employee ID. Now I want to create a report by referencing to this common data field (e.g., Employee ID) and "blend" the…
Using Smartsheet194
[email protected]
Verify All Sites Submitted Response TodayAnswered Question

Answered Amy Arnold 14 views 1 comment 0 points Most recent by Genevieve P 03/23/20Formulas and Functions

First post 03/19/20,Last post 03/23/20
Hi, I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form. I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
Formulas and Functions141
Amy Arnold
Hidden Columns in Reports - edit, print, send dialoguesAccepted Answer

Accepted Answer DJB 13 views 3 comments 0 points Most recent by Andrée Starå 03/21/20Using Smartsheet

First post 03/21/20,Last post 03/21/20
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
Using Smartsheet133
DJB
Line chart with multiple date-numbers tracesAnswered Question

Answered Jakub Gill 224 views 6 comments 0 points Most recent by Paul Newcome 03/20/20Using Smartsheet

First post 04/12/18,Last post 03/20/20
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
Using Smartsheet2246
Jakub Gill
Aggregate Summary Field Data from Multiple SheetsAnswered Question

Answered TRMakai 38 views 1 comment 0 points Most recent by Sean Morgan 03/20/20Using Smartsheet

First post 03/12/20,Last post 03/20/20
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details https://us.v-cdn.net/6031209/uploads/305/8Y65LUXQQ3QC.docx Any sugges…
Using Smartsheet381
TRMakai
Counting overdue tasks from a lot of project sheetsAccepted Answer

Accepted Answer TeeM 34 views 12 comments 0 points Most recent by Andrée Starå 03/20/20Using Smartsheet

First post 03/11/20,Last post 03/20/20
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a report that shows only the tasks assigned…
Using Smartsheet3412
TeeM
*NEW: Proofing using ReportsAccepted Answer

Accepted Answer amontemayor 100 views 24 comments 1 point Most recent by Geoff Baker 03/18/20Using Smartsheet

First post 10/01/19,Last post 03/18/20
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
Using Smartsheet10024
amontemayor
Conditional Formatting Not Updating in Reports?Answered Question

Answered Doug M 38 views 5 comments 0 points Most recent by Paul Newcome 03/18/20Using Smartsheet

First post 03/17/20,Last post 03/18/20
I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even thou…
Using Smartsheet385
Doug M
Report from multiple sheets - but automatically including new sheetsAnswered Question

Answered Christina Reid 18 views 1 comment 0 points Most recent by Paul Newcome 03/17/20Using Smartsheet

First post 03/17/20,Last post 03/17/20
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each Work…
Using Smartsheet181
Christina Reid
Seven Most Current Entries for each Question for Each LocationAnswered Question

Answered Amy Arnold 25 views 4 comments 0 points Most recent by Paul Newcome 03/16/20Formulas and Functions

First post 03/15/20,Last post 03/16/20
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. https://us.v-cdn.net/6031209/uploads/745/RJB22XU6CD5F.png This is the formula I started using based on responses in the c…
Formulas and Functions254
Amy Arnold
Any templates or sample of multiple project dashboards?

Fairorth 124 views 6 comments 0 points Most recent by Paul Newcome 03/16/20Using Smartsheet

First post 12/06/19,Last post 03/16/20
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…
Using Smartsheet1246
Fairorth
Report? Summery Count of rowsAnswered Question

Answered Xander Brennan 24 views 3 comments 0 points Most recent by Andrée Starå 03/15/20Formulas and Functions

First post 03/04/20,Last post 03/15/20
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming in: Building | Unit Number | Rent Ready …
Formulas and Functions243
Xander Brennan
Report on Tasks due including HeaderAnswered Question

Answered Andre Drinkwater 18 views 2 comments 0 points Most recent by Paul Newcome 03/13/20Using Smartsheet

First post 03/13/20,Last post 03/13/20
Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the Phase has already started. I have added …
Using Smartsheet182
Andre Drinkwater
Hyperlinks in Reports

Ginger Mason 53 views 6 comments 0 points Most recent by Ramsay Zaki 03/12/20Using Smartsheet

First post 05/01/18,Last post 03/12/20
Hi, On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location. Before the recent Smartsheet changes to reports, I would email the re…
Using Smartsheet536
Ginger Mason
Counting completion status off of a group of sheetsAnswered Question

Answered Mike Wilday 16 views 3 comments 0 points Most recent by Genevieve P 03/12/20Formulas and Functions

First post 03/11/20,Last post 03/12/20
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions163
Mike Wilday
Presenting attachments on a report widget in a dashboard

mikoker 251 views 11 comments 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 04/12/19,Last post 03/12/20
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
Using Smartsheet25111
mikoker
IF statement to update a column when box is checked!

Ashanth Suntharalingam 73 views 9 comments 0 points Most recent by Andrée Starå 03/12/20Formulas and Functions

First post 12/02/19,Last post 03/12/20
Hi, I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED. (Image)
Formulas and Functions739
Ashanth Suntharalingam
Sheet Summary Report Builder only shows the system columns

amwright100876 394 views 8 comments 0 points Most recent by Genevieve P 03/12/20Using Smartsheet

First post 08/20/19,Last post 03/12/20
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge tog…
Using Smartsheet3948
amwright100876
Combine "AND and "OR" with filtering

philippejj0421 289 views 13 comments 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 05/13/18,Last post 03/12/20
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is w…
Using Smartsheet28913
philippejj0421
ABSOLUTE CELL LINKINGAnswered Question

Answered WOODY 33 views 2 comments 0 points Most recent by Andrée Starå 03/12/20Formulas and Functions

First post 03/02/20,Last post 03/12/20
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each d…
Formulas and Functions332
WOODY
sort in reportAccepted Answer

Accepted Answer Netanel yosef 34 views 12 comments 0 points Most recent by Paul Newcome 03/11/20Using Smartsheet

First post 02/27/20,Last post 03/11/20
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i w…
Using Smartsheet3412
Netanel yosef
count tasks per week numberAnswered Question

Answered Assaf Elad 22 views 1 comment 0 points Most recent by Paul Newcome 03/10/20Formulas and Functions

First post 03/10/20,Last post 03/10/20
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COU…
Formulas and Functions221
Assaf Elad

Ask a Question

Reporting

Reporting

Discussion List