-
Cross sheet formula to pull in value
I am trying to write a formula that looks at another sheet, looks at 1 column if the column is NOT equal to 0 then it would pull in a different column's cell information. =IF(INDEX({Job Intake Form - Fence Range 1},1){Job Intake Form - Fence Range 2}>0) This is what I was thinking {Job Intake Form - Fence Range 1}…
-
Formula to calculate a total of how in a column year to date
I want to count how many have been hired A220 in the below year to date The formula I used: =COUNTIFS([Date of CJO]:[Date of CJO], @cell <= TODAY(), [Date of CJO]:[Date of CJO], @cell > TODAY(-157), Fleet:Fleet, "A220") and =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date],…
-
How to count how many are in the last 7 days
I am trying to count how many cells are in the last 7 days The formula I used is: =COUNTIF([Avature Application]:[Avature Appication], AND(@cell<= TODAY(), @cell > TODAY(-7)))
-
Divide by Zero Help
Hello all! I'm trying to calculate an average processing time when certain variables are met. Please see below: =AVG(COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team Member}, "Trenton Graf", {Agility Number}, ""), COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team…
-
Cross-Sheet Formula for Average of Column Excluding Blanks
I have three columns that are populated by column formulas. I need to calculate the average of each column and exclude blank cells in a different sheet. I appreciate your help! Thank you, Lori
-
Help with an Index/Match formula please
Hi All, Looking for some help with an Index/Match(if) formula please. Basically, if the value of a cell in column 1 = the value of a cell in column 2, then return the corresponding value which is situated in column 3. Please see attached screenshot for reference, I am working with dates across sheets. if a cell in DATE ID…
-
Trying to determine if all children have N/A Status
I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, "Complete", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 0, "Not Started"))) I want to add in…
-
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
IFs formula help
I have written a simple formula to pull the date from one column into another on every row of my sheet. ( =[Schematic Prep]@row)....converted to column formula. Now logically I understand that there are some projects in this sheet that must pull the date from a different column IF the "Survey Scope" Check box is checked.…
-
Reference a Page to calculate weight(Formula)
Hello Community, I am trying to reference a page which has certain weights assigned to the categories which the users will select while filling out the form. Based on the selection of the categories the weight is calculated and the total weight is shown. I am attaching the Screenshot of the page which has the categories…