-
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}…
-
Trying to use TODAY function
The first part of the formula below works, its only after I add ", TODAY () > [Bid Due Date]:[Bid Due Date]" that I get an error. =COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability", TODAY () > [Bid Due Date]:[Bid Due Date]) Any help is appreciated
-
Cell Linking Contact Lists
I have two sheets I want to link but I am having an issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both…
-
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
-
Counting blank cells
I need to use COOUNTIFS to count cells that are blank when TODAY is greater than the Bid Due Date. Here is what I have so far: =COUNTIFS(isblank[R2 Submitted Date]@row), TODAY (0) >[Bid Due Date]@row)
-
Help with tracking dates
Hi, I have a drop down 'Action Owner' column in a sheet and I need to track the number of days the action has been on that team. The column could be changed to a team such as Engineering more than once. Could anyone advise me on the best method for recording this data? Thanks!
-
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…
-
AverageIf Function
I'm sure there is a very easy solution to this one, but need some help... I want to capture the average of Range 29 IF Range 36 is marked as complete. I also enveloped this in the "Collect" function and the "If Error" function, but still no luck. =AVERAGEIF({Range 29}, {Range 36}, "Complete") I am receiving the "#INCORRECT…
-
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",…