-
#INVALID DATA TYPE for some functions using DATE
Hi: I am trying to generate a sum (cumulative) of all effort "points" for projects started in the current year. CASE 1: My reference columns are: "Project Start" (date) and "Effort Count (Est. Total)" (text/number). I used the formula: =SUMIF([Project Start]:[Project Start], YEAR(@cell) = 2020, [Effort Count (Est.…
-
Sheet Summary field, max date, ignore blank cells
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select the entire column to pull from so I don't have to expand the selection every time…
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
How can generate a weekly report using formula and without using a Column Helper?
Hi, Please help me on writing a formula to calculate the weekly sales data. Please see the attached screenshot of my example data.
-
Multiple sorts/countifs of different columns
Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'metadata-type' fields. I'm struggling to create summary reports of those 'metadata-type…
-
How do you pull information from the selected sheet when building a project using Control Center
Here is the situation: We have setup Control Center to build a project workspace from sheets. There are also several dashboards and a separate summary sheet. We are pulling information from the separate summary sheet into the dashboard. A number of other sheets (currently 5 but this will grow) have been identified as a…
-
Are some aspects of the templates hard coded?
I'm working with the communication plan template and even though I changed the options in a drop down list, when I work on the sheet summary report, it only gives me the original options that were on the template.
-
SHEET SUMMARY FORMULA: SUM up inventory per account and associate
Hello, I need help in formulating my Sheet Summary. On my sheet I have number of Associates with their corresponding accounts. I need to sum up the inventory per account. Ex : Jose Cruz has 3 accounts in color violet and 8 inventory. Need to show this: JOSE CRUZ | SM CITY/ SM NORTH EDSA /SM MEGA MALL | 8 JOSE CRUZ |…
-
How can I calculate if a date is before or after another date field using Sheet Summary?
I want to count how many rows on a sheet have a date in one column greater than a date in another column.
-
Metric Sheet or Sheet Summary?
Could someone explain the differences and benefits of using a metric sheet or a sheet summary? I have a project that has several grids, reports, and dashboards, and I need to add some metrics from the grids into a dashboard. I have created sheet summaries, and was using those to populate the dashboard, but have heard that…
