-
Automatically update Start and Finish dates with new week
Hi, Does anyone know if it is possible to automatically update Start and Finish dates to the new week once it hits Monday? For example, I think the formula should somehow state "When the date changes to XXX (Every Monday), change Start and Finish to Today and Today (+5)" Not sure if this is even possible? It would save my…
-
Patti P
Good morning, I would like see if you could help me with a formula…. Below is what I have and it works, but I want it to return 0 if the [PO Qty] / [Work Order Qty] are empty cells… I have tried everything I can think of….. SUMIFS, IFERROR, ISBLANK…etc…. =SUM([PO Qty]@row / [Work Order Qty]@row * 1.0) Any suggestions?
-
Does this community have a bank of shared formulas, because this might be helpful to someone
This formula is very straightforward but it took more than an hour to build, so maybe I can save you some time! This formula looks at the field "Dash Help Due Date" and returns one of five things: No Date if blank This item was due x days ago This item was due yesterday This item is due today This item is due tomorrow This…
-
Formula - IF/OR
Hello, I am attempting to take the SUM of one cell and divide it by a range of other cells to get a percentage output. However, when creating the formula I am receiving an "#Incorrect Argument" error. I need the range in the column(s) because the column "Region Name" will fluctuate with the entries that are made from the…
-
Formula to pull through names of all projects relating to a programme
Hi I'm looking for a formula that will reference a sheet that holds programme and project names. I want to pull through all projects related to a particular project. How can I best do this? I did put it in a report but, on my Dashboard it means I can't pull the data through on my metric widget. I don't want it to show on…
-
complex if/and/or question
I have 5 status columns, each with 4 possible values (Approved, Approved with Comments, N/A, Resend). I want to fill in an "Overall" Status The 5 columns are __________________ Tagless Status Front Graphic Status Back Graphic Status Right Sleeve Status Left Sleeve Status Other Status My logic is If all of the columns are…
-
Financial Year Saving Based on Implementation Date
Hi All, I have a sheet to track cost savings and would like the financial year savings to change based on the implementation date. The three fields are: Implementation Date - restricted date field. Savings Full Year - the overall savings throughout the full financial year, 01 July 2020 to 30 June 2021. Savings Financial…
-
I Need help with formula to prevent AVG Parent percentage from rolling up.
I have several (18 rows to be exact) rows that I am need to get the AVG percentage for. 17 of the rows are currently at 100% and 1 row is at at 92% (because there is one step still left to complete before it can be at 100%). When I do the formula AVG "Children", it wants to round up the percentage to 100% (the actual…
-
Max Cost per Year
I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…
-
Collect Function with Multiple Criteria
I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.