-
Net duration between 2 dates AND times
Hi folks, Ok, this is a tricky one: I'm trying to set something that was requested by many people on this community forum - a NETWORKDAYS that can account for TIME as well. In other words, the amount of working days/hours between to periods (that accounts for. There is this amazing…
-
Need help with date formula
I am trying to create a line chart widget. The chart would display the date an incident or incidents were reported on the X axis. The y axis would display the number of incidents scale. The widget would report the incidents per the last 90 days. Only the date an incident(s) was reported would display. in the chart.…
-
Adding a Title to a COUNTIF formula
I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have for the parent row: ="May 2018" + " (" + COUNT(CHILDREN()) + ")" This formula displays in the cell as May 2018 (3) ~~~~~~ I…
-
Sum total number of cartons by date
I have vendors fill out a form every time they have a shipment leaving their building. I want to create a widget on the dashboard for our leaders that show the total number of cartons leaving our vendors each day. (Bar Graph) But first, how do I create a report or formula to sum cartons by date, without me providing the…
-
Formula to count rows in a date range across columns and status
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error. =COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30),…
-
IF Formula for a sheet
I am trying to get this formula to work correctly. I believe I am close however it is not working correctly. I have attached a screen shot.
-
Nested IF using additional AND logical functions
I am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages. My formula is right now as follows: =IF(ISBLANK([RESPONSE DATE]88); "Gray", IF([RESPONSE DATE]88 <= [ORIGINAL DUE DATE]88; "Green", IF(AND([RESPONSE DATE]88 >…
-
Cross-sheet "countif" formula with three criteria
I am struggling with another Countif formula. I have a working formula in one column that counts proposals filtered by month and year. I am trying to modify it to add another criteria so I can count proposals filtered by the month year that also have the sales stage of "Asset Management Plan." The formula doesn't give me…
-
SUMIF no error, but returns '0' vs. actual sum
I'm using the Sum =SUM(CHILDREN()) to capture scoring of items by various teams, which is working great for each tool/category, but I want to now show a score by team (not just overall total by tool). =SUMIF(Tool6:Tool187, "Development", [Key factor]6:[Key factor]187) - this results in '0' (should be 35) Summing a number…
-
countif to total summary two different values into one
I have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS. So I tried countifs(Range:range, CAR, Range:Range, BUS) however that doesnt seam to work.…