-
Index Large - need 4 most recent dates in a series
Hello - I need help listing out the 4 most recent invoice dates for each project (2 are shown below). I have a separate summary sheet that lists each project and was able to use Index(Max) to get the most recent invoice date then pull in that amount. Now I am stuck trying to get the other 3. Complexities are that I would…
-
count specific item in a cell with multiple item.
I'm trying to find a way how to count an specific item in a cell with multiple item. so far i tried this formulas but its not working. =COUNTIF({Asset Health Tracker Range 1}, "unbalance", CONTAINS("Unbalance", {Asset Health Tracker Range 1})) =COUNTIF(({Asset Health Tracker Range 1}, "unbalance")( CONTAINS("Unbalance",…
-
Using a COUNTIF but need two criteria
Hello, I have a master data sheet with all my information and another sheet where I have my KPIs/metrics & formulas. I am currently using a COUNTIF formula =COUNTIF({Project List Range 1}, Labels@row) this is counting how many projects I have in each status (new, in process, pending, etc.) I would like to add another…
-
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
-
COUNTIFS not working correctly
I wan to count the number of projects that meet these criteria: Maintenance project, not an improvement project Not canceled (so status could be "Completed", "In Progress", "Not Started", etc. Matches a term code (e.g., 202110, 202090, 202060, etc.) Here is the formula I am using: =COUNTIFS([Project Type]:[Project Type],…
-
How to change and edit default time in Gantt Chart ?
Hi all, I am trying to track time for each task in a gantt chart by using the formula (=Start@row + ""). This formula displays the date and time for each task as shown in the picture below. The problem is its assigning the default start time for a task to 8:00 am and I am not able to change it. The project settings section…
-
How to show a project date extension in a Gantt chart view
I need the ability to show if a project date did not meet its original end date and how to show the new end date in a Gantt chart. Thank you!
-
Dynamic "Week Of"
Hello, Is there a way/formula I could write to get a single cell to display a dynamic "Week of XX/XX" regardless of what day today is? I want to display it for a report that will always be the previous Monday-Sunday and will roll forward the next Monday.
-
Possible to have a sheet automatically built from another sheet using a formula?
This is probably not possible, but this group is amazing and may have other ideas. I have an ORDER sheet that list various products and services (ITEM DESCRIPTION) into 5 different MARKET(s). This could be 100's or 1,000's of line items with many duplicates. Is it possible to write a formula that would go through each…
-
How To Reference Top Parent For Each Row
I'm trying to implement a formula that will reference the name of the rows Top/First Parent for each row. I have reviewed other threads on this and have not seen a definitive solution (or just one I could get to work). Ideally looking for something that could then be used as a column formula. Our sheet is organized into 7…