-
Index/Match Formula - No Match to show Blank
I've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put the right details into this cell from their reports. NO MATCH doesn't allow this.…
-
COLLECTMOD() formula
=COLLECTMOD([Return Range],"Modify Return Range",[Range 1],"Modify Range 1", "Range 1 Criteria", ...) Leave blank if there is no modification to the range.
-
How to Setup COUNT/COUNTIFS formulas
I manage the educational benefits at my job and am trying to find totals of how many dependents, drivers, and office employees participate in the benefit. This is how I've been setting up my formulas. Yet when we cross reference with Excel the total number is off. =COUNT(DISTINCT(COLLECT([Employee ID/Driver Code]:[Employee…
-
Formula help
=IF([WD Schematic End]@row = "n/a", 0, IF([WD Schematic End]@row > [STR Schematic End]@row, 1, 0)) Above formula meant to trigger a red flag if the WD & STR Schematic End dates do not match. The formula I wrote is pulling back 'invalid' ... I am missing something and cannot figure out what!
-
Formula help: Counting user experience by date
Hi there, I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N/A) for each month. For example count if a response is in September and it is positive. I am referencing a different sheet and I have tried a few different formulas but I keep getting errors. I am assuming I need to…
-
Merged: Find and Replace in Formulas Please!!
This discussion has been merged.
-
Nested IF Formula
I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range: 09/01/23 - 11/30/23 should return the value "Q1" 12/01/23 - 02/29/24 should return the value "Q2" 03/01/24 - 05/31/24 should return the value "Q3" 06/01/24 - 08/31/24 should return the value…
-
Using multiple IF(AND) statements in a formula
Hello, I am trying to create a column formula that will update Schedule health to a red, yellow, green, or blue circle using multiple IF and IF(AND) statements, but I continuously get the error message "#INCORRECT ARGUMENT SET" Here is my formula: =IF(IF(AND([End Date]@row - [Today's Date]@row <= 0, Status@row = "In…
-
JOINARRAY() function Idea
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
-
If there is no info in the second date column leave the formula cell empty or say "incomplete"
I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?