-
Nest WORKDAYS from TODAY into IF formula to return correct symbol
Hello! I'm VERY new to this, but I worked out my first nested IF formula to pull symbols based on Start & End Dates. =IF([Done?]@row = 1, "Gray", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY(3), "Yellow", IF([Start Date]@row <= TODAY(), "Green", "")))) Logic... "Gray" IF task marked Complete "Red" IF End…
-
Mark Duplicates In Multiselect Dropdown Contacts Column vs Employee Names List?
Ok, we're making a labor schedule, and want to be able to note when and where someone is used multiple times so we can prevent overscheduling someone and ensuring proper manpower. With the above as an example, I want to highlight a cell in [Employees on Job] (multiselect dropdown contacts) column, when one of the values in…
-
IS BLANK on INDEX and MATCH
Hi, I am struggling with a formula. I am trying to lookup a value from another sheet, based on a Supplier name in a column on the sheet where I require the value returned. If the Supplier is blank on the sheet that I am referencing, then it returns the first blank cell on that column instead of just an error or blank…
-
I'm stuck on a COUNTIFS formula
I'm stuck on a formula trying to get a total that only looks for specific criteria. This is what I wrote: =COUNTIFS(Status53:Status114, NOT(HAS("Backlog", Priority53:Priority114, "High"))) It's not getting the the info I need. I'm trying to find out what tasks have a "High" Priority but aren't Status "Backlog". I'm sure…
-
Can someone help me figure out why my multiple IF formula will not work?
=IF([PO Type]@row = "Standard With Quote", [Quote Amount (ESTIMATING)]@row - [PO Amount Including Change Orders ]@row),IF([PO Type]@row = "Non Standard No Quote", [Original PO Amount (Labor Only If Req) (PO Admin)]@row)) Everything is fine until I add the second "IF" statement. Thanks in advance.
-
Count the number of times a word appears in a column
Hello everybody! I need help with a formula that I am not sure how to enter for what I am looking for. I am building a dashboard on certain metrics that align with a key result. For this we have several results, two of them being Establish Success and Success. I need to know the number of projects that align with Establish…
-
SUMIF Formula with Checkbox Criteria
Hello, I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE... I can get around the issue with…
-
Pull data from one sheet into another using Index / match / contains
Hi everyone. I have two sheets and need to pull from one to the other. One sheet lists widgets and data about them, the second lists press releases and includes {press release tracking Range 2}, which is a column listing all of the widgets listed in that press release. So, the widget sheet is: Widget Press release…
-
Formula to calculate the Next [Future] date in a string of dates
Hello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get the MIN Date, However, many columns are in the past. I want the next [future] date after…
-
NESTED IF
Good day, I am struggling with this formula nested-if formula to automate the RYG status balls in the "Status "column, depending on the "% Complete" for each request. If a request is less than 70% complete, turn the "Status" column into a "Red" status ball If a request is 70% or above and less than 100% complete, turn the…
