-
Challenges with combining SUMIFS and COUNTIFS
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my…
-
Formula for Sheet Summary
Hi, Can someone help me with my formula? I'm trying to calculate the savings percentage between the Invoice Amount and Total Spend. This is the formula I’m using: =IFERROR(((Invoice Amount-Total Spend £) / Invoice) * 100, 0) But it doesn't seem to be working correctly. What's wrong with it? Thank you.
-
Count Multiple Values in the Same Column
I'm trying to write a Sheet Summary formula that will tell me how many times multiple criteria appears in one column based on the conditions of another column. I'm struggling with the OR function, and all my COUNTIFS formulas result in 0. I'm using a simple table to help me learn how to write Sheet Summary formulas, but my…
-
How Do I Return a Status/Name From a Different Sheet within a Project in Sheet Summary
Within each project we utilize Sheet Summary to pull into reporting and ultimately dashboards. There are a couple fields that I would like not to be manual, but instead use some kind of formula if I can. The issue is that the formula would have to pull the name/status from a different sheet (I noticed there is a reference…
-
Merged: Allow editable formatting in automated emails
This discussion has been merged.
-
COUNT IF Certain Project Category, resource and in Current Month
Hi! I am trying to create a sheet summary formula for each team member which shows the total files they have with a consultant in the current month. We generate a new sheet each month so i only need it to count after 1st of the month. I can't even get just a basic number of all projects with consultant after the 1st of the…
-
How to ignore #DIVIDE BY ZERO in SUM function?
I have a formula in my template Sheet Summary that I need to add the dollar amounts in the Annual Cost (Original) column. However, some of the rows will generate #DIVIDE BY ZERO. I need this formula to add only the cells that have a dollar value in them and to ignore the #DIVIDE BY ZERO. The formula I currently have in the…
-
Ignore #DIVIDE BY ZERO in Sheet Summary SUM formula
I have a formula in my template Sheet Summary that I need to add the dollar amounts in the Annual Cost (Original) column. However, some of the rows will generate #DIVIDE BY ZERO. I need this formula to add only the cells that have a dollar value in them and to ignore the #DIVIDE BY ZERO. The formula I currently have in the…
-
3 Levels of Hierarchy?
I am building a workspace with 3 separate levels: Master Overview Dashboard, 3+ team dashboards, & 5+ representative dashboards per team. I want the individual representative to be able to input data via a form and have control to edit a few columns. Each rep will "own" the data they input. Only want that data to flow to…
-
Help with sheet summary formula losing #REF with data shuttle
I have a dashboard created with a "Data Date" Metric at the top. Using the Created column to populate a "Data Date" column (text column +LEFT(Created@row, 18) I can add the date in the metric via a sheet summary field. When I refresh data pulled from an Excel sheet (exported by another program), I get a #REF error in the…