-
Date Formula
Hello! I have created a sheet, that based on the month, a workflow will be triggered to send an email out on a certain date. For example, if the month is August, Sept or October, an email be triggered to be sent on 12/15/23. If Nov, Dec or January is checked, then the email will be triggered to be sent on 3/15/23.…
-
Formula to count # of dates per month in a date column
I am trying to create a formula that will tally, by month, the number of date entries in a column. (See screenshot attached). Our non-profit provides ongoing financial counseling to veterans and each person is counseled more than once throughout the year...so I want to be able to tally each month how many new veterans we…
-
Help with a status health formula please
Hi All, we have developed a fairly basic formula to determine the health of tasks: =IF(Status@row = "Complete", "Green", IF(Status@row = "Canceled", "Green", IF(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started", [End Date]@row <= TODAY()), "Red", IF(AND(Status@row = "On Hold", [End Date]@row <=…
-
I am trying to figure out a COUNTIF with AND formula while referencing another sheet.
I am trying to create a formula that counts both if the base health is green, and if it is in shift 1. I will be doing this for all of them. If they are red in shift 1, yellow in shift 1, green in shift 2, red in shift 2, yellow in shift 2, green in shift 3, yellow in shift 3, and red in shift 3. Here is the exact part of…
-
How do you return blank if information is not found on index(match) function?
I am trying to create a cross reference formula that will link information from one sheet to another. The first sheet (Roster) that has a bunch of position data, including the position number. The second sheet (Validation Form) will be collecting additional position data over the course of the next year and it also…
-
Column deduction formula
Hello everyone Im trying to add Deduction col to my formula in screenshot/below: =(IF([📈 Monthly Target]@row <= 600, [📈 Monthly Target]@row * 0.15, 90 + (([📈 Monthly Target]@row - 600) * 0.25))) + 40 + Bonus@row I need the value amount in (Deduction) column to be deducted from total formula amount ( in Est/Salary) I tried…
-
Project plan header is not pulling/rolling up from sheet rows
I just realised the top row is not rolling up percentages, dates or durations. Dependencies are enabled, and the entire rest of the sheet is functioning fine (so I don't want to disable dependencies), but nothing is feeding that top row that feeds my reports. I just manually put in the start and end date - which should…
-
Finding a "." in a cell has me perplexed with an "!"
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Finding a "." in a cell has me perplexed with an "!"
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Does INDEX(MATCH) work on a WBS column with WBS values generated by a formula?
Hello, I have created a project schedule template for my team, with tasks, subtasks and associated timelines on one sheet. I have a second sheet where I am creating a procurement template to track our project materials. I would like the procurement template to pull the task name and target date from the project schedule by…
