-
Formula Calculation with a zero value denominator
I'm trying to create a formula to calculate the # Hours per remaining week based off the total HOURS remaining. Calculation takes into consideration the calculated remaining # of weeks on a project. Logic should be: Take Remaining hours / # of remaining weeks. If remaining weeks is < 1, simply return the amount of…
-
Problem w/Index - Match formula
I using the following formula, =INDEX({Contract Focal Point}, MATCH([Contract No.]@row, {Contract No.}), 0) And it works for the first row when i input in the contract number into the column. On subsequent rows when i input the contract number it pulls back incorrect information and if I put in a fictious number it pulls…
-
Multiple IF Statements for Various Scenarios
Hello! Based on multiple criteria, I'm building a formula to yield a completion %: I want the results to yield 0% if a specific field is marked "No" or another field is marked "No" or "N/A", populate 50% (.5) if one of two criteria are met, and populate 100% (1) if all criteria are met. I started building the formula…
-
If And Formula question
Hi, I am giving myself a headache trying to resolve the issues I am having with this formula. Currently this is set up to change the results in a dropdown Status column based on dates in other cells, its currently working well based on the above, as follows; =IFERROR(IF([Actual Submit Date]@row = "", "Pending", (IF([Actual…
-
Formula to generate series of dates
Does anyone know how to write a formula to have a series of dates generated based on entry of a starting date? In excel, you can enter starting date of 5/1/23, the next cell can can be +7 days so the date is auto generated to be 5/8/23, 5/15/23 etc. I can't figure out how to do this to save time for user since they have to…
-
Multiple If Statements not working?
Hello, I'm trying to setup a multiple IF statement but I'm encountering an error where the 2nd multiple if statement does not run. The first statement runs correctly but the subsequent statements always fail. The Formula: =IF(INDEX({Area 1 (AMER) QC sheet Range 4}, MATCH([SIM T: Customer Request]@row, {Area 1 (AMER) QC…
-
Is there a way to reference a summary field from one sheet in another sheet?
I have sheet that contains master data for customers. The master data customer sheet has a set number of support hours available for each customer. I have another sheet that is collecting support hour information for the customers. A summary field has been created for each customer that sums the support hours for that…
-
Formula to sum rows from one sheet based on a date range to a field on another sheet
Hi! As a brief summary, I have created a sheet for our laundry staff to keep track of how many items are being laundered on a daily basis. I have created a separate sheet for monthly totals of each item laundered. I am trying to create a formula that will sum the total number for each laundered item within each month. For…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
Check to see if a row is a Parent
I am trying to check if a row is a "parent". My definition of a parent is a row that has any children or a single row with no children. I have a column, called isParent, that I am adding to each row a 0 for not a parent (so a child row) and a 1 to the parent row I can get if the row has no children with this formula…