-
nesting properly?
Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cells contents with: =-SUMIFS({Transactions Range 1}, {Transactions Range 4}, ="Issue",…
-
7 Day Average/30 Day Average
I am trying to build a formula for a data set that I can calculate as a complete average, but I'd like the 7 day average and the 30 day average. Here's the formula that works: =AVG([% Successful]:[% Successful]) I know I will need to use AVERAGEIF, but can not get the date parts correct. Thanks for your help!
-
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.