-
Column Formula to count (and sum) 'Waiting Days'
Hello, Can anyone suggest a way to manage this? I'd like to be able to count up time spent awaiting feedback from our client across various projects held in the same sheet. Essentially I need to be able to count the days between when a Version is sent and when Feedback is received. If Feedback is received on the same day…
-
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…