-
How do I add another IF statement to a Workdays calculation?
I am using the following formula (from a template) top calculate Working Days Remaining for a task - =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to add a condition to this that if the Status column for that same row is marked complete, then the Working Days…
-
Formula to show the number of items that meet 2 criteria
I am looking to tally up the number of tasks that meet the following criteria: Don't have a check in the column "Done" Have a due date within the next 14 days I am actually going to create 3 buckets (due within the next 14 days from today (whenever it's opened), due between 15 and 30 days and due in over 30 days). I tried…
-
Formula for Max Value and Row Name
Hello - I am trying to pull in the max value of column A and the name(s) associated with that value. I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value: =LARGE(DISTINCT([B]$1:[B]$7), #) And then I would like to show the value(s) in…
-
countifs from a multi-select to count two items
I have a multi-select field with 3 items (ex: A, B, C). I want to be able to get a count for 1) cells with A and B and 2) cells with all (a, b, c). Running into trouble. I've tried: =COUNTIFS({acct type}, "Signed Account", {Product}, "Zonehaven" + COUNTIFS({acct type}, "Signed Account", {Product}, "GEM"))
-
Creating a custom number formula with conditions
Hello! I am trying to create a formula in which a row is automatically assigned the next number in a series if the progress column blank, "Not started," "Processing," or "Equipment checked out." If the progress column is something else ("Wait list," "Completed, Equipment returned," or "Completed, No response"), then no…
-
Countif Help Getting #Invalid Operation
I have two columns of data. In one column I have a formula that looks for Ownership Changes (=COUNTIF([Service Request Record Type]:[Service Request Record Type], "Ownership Changes") In another column I have a formula that is looking for Management Company Change Requests (=COUNTIF([Billing Request]:[Billing Request],…
-
I am trying to count the number of times 2020 in one Colum appears when January is in another Colum?
=COUNTIFS(Year:Year, "2020", test:test, "January") I am getting a #invalid data type error
-
If/HAS statments
I am trying to create a function where if a certain name is populated within a column and another column is today or greater the harvey ball turns red. The If/Has does not like looking at a date column. I can get the name part to work and have it ignite the Harvey Ball but, then can not get the date piece to work in order…
-
#DIVIDE BY ZERO Error
Hello - I get this #DIVIDE BY ZERO error when I try to take the average on multiple criterias. Here is my formula: =AVG(COLLECT([Target Date Variance]:[Target Date Variance], [Design Team]:[Design Team], "Experience Design", [Design Team]:[Design Team], "Prism Core", [Design Team]:[Design Team], "Platform Vertical")) I…
-
Copy Primary column data to Contact list column
Today we have a primary column with the user information but defined as Text field. We are looking to have it as Contact list but as it is a primary column we cannot change. As a work around we created a new column but how can we make sure that column is filled in from Primary column ? I see there is no option to make it…