-
Sheet Summary equation
I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is…
-
Sheet Summary for Dashboard
So i have multiple sheets (15) which are all using the same template of marketing events. i created a dashboard which shows upcoming events in the next few days based off a report (pulling from the 15 sheets). I would like to add a metric on the dashboard which show (for example) how many webinars we have going across the…
-
Can a sheet summary always reference the same cell when form entries are added?
I am trying to create a sheet summary that pull information from a form entry. The form entries will always appear in the first row. However, even when referencing the absolute cell, when a new form entry is populated, the sheet summary field displays the previous row (now row 2). Is there anyway to always return the top…
-
Can I set sheet to show the sheet summary when a user lands on the page?
I'd like to display the sheet summary when a user lands on sheet, and keep the summary open until a user dismisses it.
-
Report: Sheet Summary - Update Field from Report
I'm trying to find a workaround the lack of functionality in Update Requests. I have a Sheet Summary field called "Project Update" where our Project Lead is expected to put a brief statement on their project weekly. That field feeds up to the Project Dashboard and, subsequently, a Portfolio Dashboard to provide an update…
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…
-
Sheet Summary
Hi, I am writing a formula that is using data from sheet summary. I am blanking on the symbol used either before or after to pull in the field from sheet summary. Thank You!
-
If a date is between 1.01.2020 and 31.12.2020, get the cell checked
Hi everyone, I have a list of documents that have been uploaded throughout different years. I would like to count how many of them have been uploaded in 2020. For this reason, I would like to create a column where the cell will be checked if the column "Date Uploading" is in 2020 and then report it on the Summary Sheet. Is…
-
Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard
I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of…
-
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…