-
Date + number of days calculation in summary field
Hello, I could use some help in how to write a formula is my summary section where it uses a "Start Date" field from the summary plus a number of days. For example, If the Start Date is 01/01/24 and I want to know what the due date is which is 70 days later. The due date field is also a field in the summary section. Thank…
-
RAG Status based off Number Range
Hi- I came up with this formula to define RAG Risk Score based off a number or a range: Green = Risk Score of 3 or less Amber = Risk Score between 4 & 9 Red = Risk Score of 10 or more =IF([Overall Risk Score]1 <= "3", "Green", IF([Overall Risk Score]1 = "4-9", "Yellow", IF([Overall Risk Score]1 >= "10", "Red"))) However,…
-
Checking a box if multiple criteria are met.
Needing a little help, I am needing a cell to have its box checked marked depending on certain criteria. I have the basics but the road block I'm running into is the last criteria and I know I'm missing something. I am needing the blue box to have it's box checked. I have it linked to another sheet that this sheet is…
-
Partial cell population
I have a Part Number column The part number is combination of letters and numbers. The majority of the number is the same each time with only the last three digits changing. The column does not run in numerical order as the part number may appear more then once. Is there a way for the cell to populate the complete part…
-
Sumifs Multiple Criteria
I have this formula that i'm currently using. I need to add some more criteria to the formula and need some help. current formula =SUMIFS({MASTER SCHEDULE Range 1}, {MASTER SCHEDULE Range 2}, "Marc Holbrook", {MASTER SCHEDULE Range 3}, "DESIGN") {MASTER SCHEDULE Range 3}, "DESIGN") and I need "AGREEMENT" Also the first…
-
Subtracting Days from a Date
Hello, I am trying to subtract 30 days from a column pulling in dates from another sheet using formulas and it keeps yielding an #INVALID OPERATION error. I have already checked and do not have dependencies enabled. Both columns are formatted as date columns. While playing around I noticed when I add the days it instead…
-
Percentage of ticked boxes completed. Column total.
I have used Countif formulas to calculate the total completion of ticked boxes for the row of columns but I am having some difficulty finding the total completion of the columns. Can anyone help me establish the correct formula to gain the total of ticked boxes for a row. I am fairly confident that the formula is correct…
-
Reminders
I have a sheet which is used by several members of the team. Is it possible to find out how many reminders are set for a particular date? This would help manage workflow in the office. Thanks in advance
-
Formula that can read multiple cells and return a value from one cell.
Hello! I'm looking for assistance with creating a formula to return a value in the Formula Result row pictured below. The formula I'm experimenting with should read the cells within the 6 rows. For example, in the first row, the formula result should say "Draft", and in the second row, the formula result should read "Sent"…
-
How can I look up a set of values in a column for a dashboard metric?
The end result: I want a metric on a dashboard to show rows of a sheet that meet certain criteria. Background: I have a sheet that has, among other things, a column that shows quantities of an item from a form (using the sheet as a survey response form). I want to find any rows that have a value of 10 or less, and show…