-
count if check box is not checked (2) and requested date is within a date range
I am trying to get a count of each row on my sheet that meets the following criteria. Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18 and Children of (Canceled17) (which is check box format) is not checked (0) and Children of ([Not Owner]17) (which is a check box format) is not…
-
Nested IF and Forms
Good morning. I created a meeting request form for business units to fill out so we can capture information we need about an upcoming conference. I'm trying to rig the way the information is captured on the sheet and am having a little trouble with the Nested IF. I have columns for each meeting date and a drop-down option…
-
Referencing a predecessor in formula
Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".
-
Average of multiple rows
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet. Any ideas would be…
-
Dynamic lookup for Project Master Rollup
I would like to create a master project rollup to track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user has to do is type the name of the sheet referencing the new project into the master rollup?
-
Populate Dates Between a Start Date and Finish Date
Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a basic start date for the job, and a finish date for the job. This shows it nicely on the gantt chart and all the days that are…
-
Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
-
count how many times a "Department Name" comes up with completed date
I want to count how many times a "Department Name" shows up once a complete date has been entered into the date "Completed Date" column.
-
Formulas
Hi everyone, I am back again :( . I am trying to figure out how to write a formula that will SUMIF column "Status" is "Active", column "Current Phase" is "Discovery", and column "Discovery Total Time" is populated with a number. The last column will change as the phases are completed. I have attached a screen shot for…
-
Automate RYG balls using two colums with IF/OR & IF/AND
I have successfully automated the RYG balls to show a different color as we get closer to a due date, and then show "OVERDUE" when the due date has passed (Urgency). (Days1 is a hidden column that counts the difference between today's date and the due date) Here is the successful formula: =IF(Days1 >= 7, "Green",…
