Sheet Summary
Discussion List
- 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…
- 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 c…
- 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 i…
- 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 t…
- 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 t…
- 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 …
- Is there any way to find out how many sheets in my account are using forms? (Short of opening up each sheet and clicking on Manage Forms! We have way too many sheets for that!) We need a way to estima…
- 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 sh…
- I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clear…
- I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). …
