I'm trying to get a rolling 4 week count. So this week would only count the "X" in week 8 back to week 5, for example.
I've set up a list of associates to pull their daily error count. When the raw total changes from zero, it updates a second sheet that only has these two columns (I have more columns in the original sheet that I don't want pulled for my final sheet, so this is a "helper" sheet). I've set an automation for this sheet. When…
I have a function that’s returning the top 5 values. However when two or more lines have the same value, its only returning the first fty in the list. So as below, instead of returning APU002 as the second with 3 occurrences, it lists A2B001 a second time. Formula used is =INDEX(COLLECT(Fty$1:Fty$5,…
I have several charts on a Dashboard that are pulling from multiple sheets. Within the sheets, the functions work with no problems at all. Suddenly the page seems to refresh and the charts shows "unable to Display" message. When I open the sheet the chart is pulling from, it briefly shows #Invalid Operation. Before I touch…
