-
Countif the Month/Year matches the current Month/Year?
Current formula displayed at bottom. It counts the amount of Values in Range 1 that are created in the last 30 days. The formula works, however I'd like to change the second countifs statement, in particular the Today(-30) so that it matches the month/year of the date. That way, it will track the Values in Range 1 created…
-
Did the COUNT formula change to include blank?
I want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes. Does anyone have any idea why this changed?
-
Display Number only if 2 conditions are met
Good morning, I am trying to display the lowest bid in a column only if the [BID AMOUNT] cell is not blank AND if the checkbox under [UNVETTED] is NOT checked. For the first half, I have this: =IFERROR(SMALL([BID AMOUNT]40:[BID AMOUNT]44, COUNTIF([BID AMOUNT]40:[BID AMOUNT]44, 0) + 1), "") Which works exactly as I want.…
-
sheet summary and I need several formulas
I have a sheet summary and I need to have several formulas 1-How many requests total? =COUNT([Date Received]:[Date Received]) 2-How many requests from Group "A"-Group "B"? a) which has the most volume? b) what formula to use percent as well 3-How many actual staff has been requested? (FYI- there are 6 columns for group A &…
-
Formula that will allow a date in text format to be captured in a date format
I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows. So far I have tried these 2 formulas without success: =DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable…
-
Dashboard, column cut
Dear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also not the reason why it's cut. In the report, the column is shown as it should be. I…
-
Counting tasks throughout the year
Hi, I'm counting how many times certain tasks has been added to the list of TO DO of the year, Meaning for instance if one of my teams (there are 4) has added to the list of day1, task1, and task2 (a different color for every task). My problem is that it doesnt count unless there's only one task in the cell. If for…
-
Nested IF formula with Multiple conditions
Hi, I am trying to create a formula in the status column and I keep getting an error message. I wanted to make the status column a calculation to limit the amount of work the editors has to do. I have never been great with nested if statements, but I got it to work in Excel. I was able to get a simple If statement formula…
-
Why doesn't my Automation with a email work?
Hello! I have set up an automation, where when a specific cell is changed to 85% and above, where a specific name is, it should notify the person and administrator. And my problem is that it doesn't notify the people. Note: there are about 24 conditions. (Picture below for reference) Hope you can help!
-
Countifs help
I have a sheet that has a column for the date and the second column that states "yes" or "no" beside the date as to if we have had an accident. This second column is called safety. I am trying to write a formula to count the number of days since the last time I input a "yes" in the safety column. Each time I write my…