-
Triggering the Flag (symbol) based on 2 Conditions
I want to trigger the Flag symbol based on the conditions of 2 other cells: Completed COUNT Days If the COUNT Days are < 1 AND the COMPLETED is not CHECKED then FLAG = 1 (Red) (ie. still an active action) If the COUNT Days are < 1 AND the Completed is CHECKED - FLAG = 0 (White) (ie. Action is Complete no need to issue a…
-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
Keep current cell value if there is no match with index/match
Good Morning, I would like to use an index/match formula on this sheet. It would update the wood/metal/glass columns if there is a match to the tracking # on another report that would be updated. If there is not a match, instead of returning "no match" I would like to keep the current selected values in that cell. Is this…
-
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…
-
COUNTIFS if a Date cell is within 30 Days
Hi, Is it possible to COUNTIFS with one of the criteria being a date that is equal to or within 30 days to that set in another cell? In the past I have used a helper column to count the days and just count the cells that fell within the number of day <=30, <60, etc. Any help would be much appreciated. Thanks Richard
-
Multi Drop Down Formula
Hi everyone, I am trying to put together a formula for an ethics check process. The user needs to select all of the items in the drop down list in order for the client to pass the ethics check. I would like to set a formula that automates Red, Amber, Green. I would like the following; Green if ALL of the options are…
-
Date Range in formula unparseable
Hi I would be very appreciative if someone could help me solve this date range formula. =COUNTIFS(Status:Status, "Complete", [IS&T Services]:[IS&T Services], "<>Public Safety", [IS&T Services]:[IS&T Services], "<>Cross Functional", [IS&T Services]:[IS&T Services], "<>SubProjects and Tasks", [Actual Finish]:[Actual Finish],…
-
How can I count a range of dates based of a condition?
I'm trying to keep a tally of how many cancelled dates per month for each state/country and I can't quite figure out the formula to make it work. Can someone please help me?
-
I need to calculate past due items with 2 column dates
Hi I need to create a formula that help me to calculate the past due items but using to columns with dates. One is the the first column with the "Expected closure date". This will be the primary column to check or validate. But we have another one called "Amended closure date", that will have another date that probably…
-
Need to set a Workflow for two items
Anyone know how to set a formula: If Request is more than 20 days out and another field is blank? I have this for the 20 days, not sure how to get the other part. =IF([Date Requested]@row < TODAY() + 20, true, false) This will be in a Check Box that looks at the Request Date (system generated) and the Start Date (populated…