-
Charts to show field averages
I have a survey - there are 10 questions that are ratings - symbols 5 stars. I need to create a graph that shows the weekly average rating for each question - prefer a bar chart. I've created a report to filter the data for the last week. I have a dashboard and see the chart widget. However, I can't figure out where to use…
-
Issue - My Assigned Task Report Attachment
Hello, Please share this feedback with the appropriate engineering team. When scheduling a recurring delivery of the My Assigned Task report via the Send as Attachment feature, the attachment populates tasks assigned to me (the sender) instead of the recipient. We are currently embedding the link to the report in the…
-
Only Show Row if Data is in Specific Columns in a Report
Hello, We have project names, resources, and project managers all listed on the same row with the hours worked on particular days. I'd like to build a report, or a sheet that only shows rows if hours are listed past a certain point, meaning only show rows that have hours listed in the date columns. This will eliminate a…
-
Remove the need for duplicate reports in a dashboard
I have a sheet listing data from several different projects and would like separate dashboards created based upon the project data in the sheet. I can do this easily for one project and just add a filter for "Project = ##" to pull in a specific projects data. However I now have the conundrum of creating about 10 different…
-
Add new rows/line items in reports
Bi-directional information is what makes reports awesome. Being able to add new rows directly within a report would be helpful if I only want some people working in a certain report so that they only see certain information. They could then work directly within that report and not have to bother with other reports/sheets.
-
Linking Parent and Subtasks from a sheet into a report
Hi! I am creating a report of tasks that are in various stages, and some of the tasks have a parent/child relationship. I already tried the 'Helper column' to identify parent tasks. Is there a formula to use to identify child tasks? Also - Is there a formula I could use where instead of just listing the Parent Task Name in…
-
Dynamic View Between 2 Departments with 1 source sheet
Hi! I was hoping someone might be able to assist me with a crazy idea and see if it's possible or if there would be a better option. Here it is: I'm wanting to create a single source sheet that would serve as the foundation of a data warehouse. It would have 2 dedicated admins who would act as bridges between both…
-
Grouping data by month and sorting it chronological way in a row report
Hello everyone, I'm trying to create a report in which the data pulled in (in this case "submissions"), is grouped in months (i.e., 3 submissions in August, 5 in September, 2 in October, etc.) as to show which months are busier. The grouping and the sorting tools though, in their options "sort ascending" or "sort…
-
Why is my Excel exported from a report empty?
Hello, I am trying to solve an issue I am having with exporting data from a report to an Excel sheet. We have a financial report that is exported to Excel on a weekly basis. This week when our employee went to create an Excel export of this report, the excel had no data and only showed header names. I tried exporting this…
-
How to filter anything that has been marked complete in the last 30 days
I am trying to set up a chart so that any project that has been marked at complete in the last 30 days will show up in there. I did this by filtering in the report for any due date that is in the last 30 days, AND has also been marked complete. But I am realizing now that it may not be the best solution, as sometimes…