-
Countifs- if cell blank then count by other cell
Hi I currently have following formula counting number of projects with status completed in EU and checking base date monthly: =COUNTIFS({production date}, <=DATE(2023, 1, 31), {base eu kof}, >=DATE(2023, 1, 1), {status}, "Completed", {division}, "EU") However some projects don't have "production date" they've got another…
-
"IF" Checkbox function question.
I have several checkboxes in my SS. I would like each check box to represent a cost to be added to a "total cost" field. (i.e. if Checkbox 1 is checked, add $2,750, If Checkbox 2 is checked, add $3,750, etc.). Can someone tell me how to accomplish this? Thank you!
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…
-
WBS Formula help
I am trying to join the WBS formula to include another level or substep ID formula = IF([ID_Parent]@row <> "", [ID_Parent]@row, JOIN([ID_Child]:[ID_Child], ".", [Child_Count]@row)) I want the result to be WS1.1.2.1 instead of just displaying .1 under WS1.1.2
-
Monthly Calculation
I need to calculate monthly expenses but I've managed to stump myself on the formula/function. Here is my use case: I've got individual line items by user, but I want to sum their monthly expense by month. I have a range the individuals are contracted with us...say from 7/1/2022 to 5/31/23. How could I write the formula to…
-
Using COUNTIF with IF(AND
Hi! I'm fairly new to formulas and not sure where I'm going wrong here, any help or insight would be greatly appreciated :-) - thank you! I'm trying to say, in a Metrics sheet, "please count this status if it is "Not Started", checked as active (it's a checkbox column), and says "Near-Term" in the drop-down field in that…
-
AVG Collect Formula Help
I am looking to add to the formula so that if {APD CI Tracker Range 5}, ="Pilot/ Implemented" the Dashboard reads "Pilot" OR if {APD CI Tracker Range 5}, ="Monitor/ Check" the dashboard reads "Monitor" and if {APD CI Tracker Range 5} is not Working, Pilot/ Implemented, or Monitor/ Check the Dashboard reads 0 Current…
-
INDEX MATCH with two criteria
Is there a way to reference a ROW and a Column and return the data? So in the primary column, I have project numbers, and in the first row i have pasted column names, so I am looking literally look up the cell (by Row and column) not using Index only, because it requires column numbers, but using match.…
-
Help with SUMIF formula
Hi everyone, Can you help me to figure out what is the correct formula to use in this case? I want to sum only the rows that have the following criteria: "Projected" or "General Foreman", or "Foreman". I don't want to sum up the other rows. The formula I was using to sum only projected was this one: =SUMIFS([Mon, 17,…
-
Adding another parameter to IF(OR) with multiple conditions
I have a formula working exactly how I want it to, unless I add one more parameter (checking a checkbox), in which case I don't even know where to begin. Would that be an IF(AND(OR))? If so, can someone help me with placement? The current formula which pulls from [Docs Check Date Helper], [Cargo Ready Helper], [Latest ETA…
