-
I need to SUM points based on user and then sort by aggregated points
I have a sheet similar to the one below: I need a way to display my results like this: I can create a report but it won't sort it based on the aggregate function. Any help would be much appreciated.
-
Does anyone know if its possibly to use INDEX MATCH to pull in images?
The formula seems to be working but it pulls in the PNG name and not the image. although the image name doesn't match. I am not sure what is going wrong. it looks like it is pulling in the name of the last icon image. Does anyone have any tips?
-
Why is MONTH returning the wrong month?
I'm using the MONTH function against a Created system column. This Created column has date and time. For values on the last day of the month after 8pm MONTH is returning the next month. For example: Created = 9/30/2021 8:52pm MONTH returns 10 I'm guessing that this is because the system column is actually storing the time…
-
Extract a Number from a cell, the position of the number varies
Problem: I have a task name column and within this contains a number that I'm trying to extract. The number is always formatted with CRXXXXXX. The location of CRXXXXXX in the column varies from row to row. Goal: I want to extract the number from the task column. Example: CR123456 would be 123456 a new cell. I have seen…
-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
COUNTIF formula with CONTAINS not working
I am having an issue when adding a "contains" function to my "countif" function. I am hoping someone can assist. The current formula that I am using works perfectly for COUNTIF =COUNTIF({Import RFI's Range 1}, "ADCVD") When I convert the formula to include CONTAINS I get an INVALID ARGUMENT message.…
-
Index/Match Question, Display Time of meeting based upon the date
Here is my problem: I have 2 standing meeting slots, one on the morning and one in the afternoon. A meeting can be scheduled during the morning, during the afternoon, both, or none. Here is my need: I wanted to show if there is a meeting in either slot on a given day. Right now I can show if one meeting slot is filled but…
-
Dashboard chart for daily submissions (via form) over time
I have a seven week event. I have a form set up for submissions about the event. How do I set up the metric sheet and which formulas to count submissions each day/ week to appear on the chart to show on the dashboard.
-
COUNTIF that will only count child rows when present
This is another slight spin off of another question I had asked. How would I structure the COUNTIFS formula to ignore the parent row if child rows are present? The main formula I am using is: =COUNTIFS({FOLLOW UP Range 2}, AND(@cell > DATE(2021, 1, 1), @cell < DATE(2021, 1, 31)), {Follow Up Contractors}, FIND("ACCURATE",…
-
How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)
We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from? Can anyone provide some direction? See Row 18 in the attached screenshot. Thanks! Des