-
COUNTIF(AND) FUNCTION
Hi again, I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met. the date is in the past the progress status is not "Complete" =COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range},…
-
Check for overlapping date ranges between sub tasks
Hi, I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project. In the screenshot below the project has several sub tasks and I need a formula that will identify any overlap between the dates on the tasks. I would like to prevent the use of references to cell numbers because…
-
Averageifs Question
Hello! I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria? Right now, I have this equation, which works for when just hitting the one criteria: =ROUND(AVERAGEIF({System Request}, [Ticket Type 2]1,…
-
Formula Error
Hello, I continue to encounter an incorrect argument error however the formula worked correctly with a previous entry and I cannot determine the cause. See below: Error encountered with top entry The formulas are precisely the same with the exception of references and I've checked the formula probably 20 times now and…
-
Countif not working for duplicate check in column
Has anyone been having issues with the countif formula to check for duplicates in a column? My output keeps showing zero even though there are 2 of the same numbers in one column.
-
CONTAINS formula always returns no match
I have a Row Counter column created with this formula: =COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> "")) . It is designed to house row numbers so I can reference that number in another formula. I have the column Is Predecessor created with formula =IF(CONTAINS([Row Counter]@row,…
-
Use of WORKDAYS or NETWORKDAYS to return weekday date on a calculated date field
I have two kinds of calculated date fields in columns that work, but I need them to only return weekdays/workdays. Is it possible to use WORKDAYS or NETWORKDAYS on a calculated field to only return weekdays or workdays? Here are the date field examples: .....PlannedEnd2 equals PlannedStart2 plus 5 days......…
-
Is there a workaround that would equate to the IN Operator in MS Access?
I'm using Document Builder to populate an HR form that is used for multiple purposes. I have a single select drop down column with 17 pre-defined choices. Several of those choices require a new position number (PSN) to be entered and many more do not. In the instances that do not, I would like to create a formula to copy…
-
Count and Distinct Formula returns 1
Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so…
-
Display RYGB Circles based on dates in multiple columns
Need help trying to display the RYGB circles based on values in other columns. So, say we have columns that are ActualStartDateStep1, BaselineFinishDate, CalculatedFinishDate (meaning calculates on the fly as other dates are filled out, re-forecasting the possible finish date), and ActualEndDateStep7. (I have multiple…