-
How to count total checked in report instead of just total number in report?
I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the check mark. Instead it is currently counting the total number in the report, checked or unchecked. I am using a report for…
-
Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to. =INDEX({Census}, MATCH(Date@row,…
-
Is there a way to delete a cross sheet reference?
I had a working formula referencing another sheet. It was referencing a set of cells in a column. I changed it to look at the entire column and started getting an #Incorrect Argument Set message. I tried to change it back to the range of cells and I'm still getting the error message. I wanted to delete the cross sheet…
-
Formula help for date <90 days and text "includes"
So really stumped on this one, my formula is working with the exception of the text including "Test". I need to have a star (1) put into this cell IF: Column [Expiration Date] is <= 90 days from today AND another column (Client) includes the word "Test". My current formula (auto-generated) is not working, any help is much…
-
Distinct CountIFS Statement
I need a little assistance... I was able to get the formula to partially work using =count(distinct but, it was not taking the name cell into account and returned the same number in each row. I need a distinct count of PrAbv based on P Name. I got "#inccorect argument" when I changed count to countifs. I'm sure it's…
-
Average symbols for growing number of columns
Hello all, I know this is likely possible, but I've been struggling to think of the most efficient process. Below is a sheet I'm working on, where trainers enter progress for a trainee in a given "soft skill." These trainer columns will be added automatically on a daily basis via an outside Power Automate flow, while the…
-
Index Match References Disappearing
I am experiencing glitchiness around programmed index match references disappearing. The sheets I have linked will function fine for a period of time and then we will notice the data begins to simply not populate in the receiving sheet. When I look at the index match reference, its gone and I have to remap it. Our formula…
-
Streamline Sheet Reference Manager
I just went through an update where I needed to manually add 3 new sheet references to 26 Stakeholder Registers (78 total). I wish that after you click Insert Reference, the Sheet Reference Manager dialog box would remain open.
-
Date (mm/dd/yyyy) from Week number
I am trying to get the date displayed from a week number. For instance this week is the 27th week of the year. I am trying to get it to display 07/05/2021 (the first day in the week). I was thinking of converting the week to day of the year (i.e. 27 * 7 = 189) and using the 189 to convert to a date, but I can't figure out…
-
Cross-Referencing Assigned To Error
I am building out a roll-up sheet and have everything working nicely, with the exception of a single formula. The part of this sheet I'm having trouble with is in the image below. What I am trying to do is have this sheet look at the person named in the column "Primary", then check a couple other sheets to see how many…
