-
Nested Index/Match works but getting #No Match would like to return blank but can't get formula
=IFERROR(INDEX({Braden's Project List Range 4}, MATCH(Project@row, {Braden's Project List Range 3}, 0)), INDEX({Braden's Project List Range 2}, MATCH(Project@row, {Cody's Residential Project List}, 0)), "")
-
Nested If formula help
Below is the formula I am attempting to use. It works perfectly if I my Auto Pay row is No or when the due date has not yet arrived but it doesn't put in the amount in the due row if the date has arrived. What do I have incorrect. =IF([Auto Pay]@row = "yes", IF([Due Date]@row <= TODAY(), Due@row, 0), SUMIFS({Amt Pd}, {Bill…
-
Formula
Hello again, I need help with how to set up a formula for my dashboard. How do I create a formula that tells me how many Task and CAR's were issued per month? Please advise, thanks!
-
Count If for Workdays
Hello, I have a sheet that has a column with a bunch of different dates on it. I'd like to easily be able to visualize how many of those dates fall within the 1st week of the month, 2nd, 3rd, etc. I'd like to organize it by actual workdays rather than dates. Any suggestions for how to display that data? One thought is to…
-
How can I count items only when 3 specific criteria are met?
Hello All, Novice user here - I am building a data sheet for metrics and am hoping someone could please help me figure out the best way to create a COUNTIF/IFS formula that will only count a status 'type' (Complete, Scheduled, etc.) if the Core OpCo is 'FLA' and the year is 2022 and the LFCM OT box is 'checked/True'? I'm…
-
IF Function too long in Sheet Summary
Hi, I have an IF statement that is too long to add to the Sheet Summary Field. Is there a way I can shorten it? Please see below. (I've already created one that with less criteria that works, but want to add one more criteria to the formula.) =IF(AND([Learning Done]1 = 1, [Learning Done]2 = 1, [Learning Done]3 = 0,…
-
Average Formula not Ignoring Blanks
Hello! I am having problems with the below formula (its a big one). I am trying to avoid creating 9 helper columns if possible. The below formula is including blank cells as 0s when averaging. I have tried a variety of combinations of OR, <>0, etc and cannot find a way to skip the blanks. Some of what I have tried will…
-
Formula to display each month and year of biennium
I am needing help with a formula to display the text month and year or the numeric month and year of each month of a biennium. I am currently developing a "template" metric sheet that will pull data from a report containing various months from the biennium. From this a dashboard will be developed. The metrics sheet…
-
Using COUNTIF and CONTAINS
I need to count the number of times a word is found in a cell. My constraint is that the cell can contain multiple words (from a dropdown) and I'm not sure the formula to use. COUNTIF works just fine if the cell only contains one word. I see a report that used both COUNTIFS and CONTAINS but I can't get it to work. The…
-
Subtracting Velocity Point(s) Value in row, and in column
I am wanting to create a column in my project workflow that will show how many story points I have remaining for the sprint or release. I have a snap shot of the sheet that shows Checkbox column for Started and Done, a Status column based on checkbox on or off, Velocity(story points) and remaining velocity. Hidden is the…