-
Count Info Across Multiple Sheets
Howdy! I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and…
-
statistics on multi projetcs
Hello, I am working on many project and my boss want me to say which task is finish in advance, in time or late compare to the initial date calculated. ex: when the project is finished we want to know which tasks are good and which are wrong. the task drawing start the 2015 01 01 and must be finish the 2015 01 30 if the…
-
Reporting - % Complete filter not working?
Tried to filter for tasks that are LESS Than 100% complete, however 100% tasks are displaying.
-
Summarize Columns in a REPORT, not a Worksheet
I've looked far and wide, and haven't found a way to summarize column data in a Report. My team uses a single "Status Tracking" Smartsheet, which has a large number of columns. For some of the columns in that worksheet, I have created Summary Rows with Count or Average Formulas, so I can determine the number of records for…
-
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
-
Report not sorting on given column
I have a report that is not sorting on the column I specified. It was working yesterday, but today it is not working. It is to-do list report that is sorted by Forced Rank. I can sort by other columns (e.g., Due Date), but for some reason the Forced Rank sorting is not working anymore. Forced Rank is a Text/Number. Forced…
-
Populating existing sheet rows through a form
I'm looking to collect weekly sales reports from a number of sales teams spread across different countries. Ideally I want the data from each weeks sales report to drop into a row (with the week number and/or week end date) in my master sheet. Some of the data in the master sheet will be pre-populated (overal…
-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
-
New Published Reports
Hi, I would be interested in what people think of the new way of publishing reports. I have had a customer come back to me with negative feedback. It looks and feels like a smartsheet not an output to place in a Webpage as part of a dashboard of Reports, charts and other information. The older style looked like an output…
-
Smartsheet Reports going directly into a sheet as an attachment
Hi, I wondered if anyone knew how to upload a report directly into a new sheet? At the moment I email the report that I have run and add that report as an attachment to another one of my sheets, is there a way this can be done missing out the email link? I'd love to run the report as an excel document and attach it to my…