-
COUNTM Formula
How can my COUNTM Formula only capture those projects where efficiency gain is 1 of the benefits selected for that project. Project currently have more than 1 benefit such as "Efficiency Gain". I am currently entering the formulas below, but not sure what else to do. =COUNTM({MH-Work Prioritization Log Range 2},…
-
Countif and Has returning 0 from multi value cells
I have a column that has the option to have multiple values. I created a calculation sheet so I can use the data in a dashboard, so I need to count the number of "GovDoc" and the other values but it keep returning 0 I'm using the following formula =COUNTIF({Issues}, HAS({Issues}, "GovDoc")) What is wrong?
-
BOM - INDEX/COLLECT Formula referencing child rows only in another sheet
Hey there, If anyone can help. I have set up two calculation sheets. The first is a Bill of Materials with the second being a variations sheet where I can combine various options from the BOM sheet. Each BOM item has a corresponding unique ID number. In the Variations Sheet I want to have a list of the BO so I can easily…
-
COUNTIFS, CROSS SHEET, HAS, MULTI-SELECT DROP DOWNS AND MULTIPLE CRITERIA
I feel like I've been going crazy. Trying to get a count of how many [Primary Column]45 appear when the other ranges have the listed criteria. All ranges are multi-select drop downs. Keep getting 0, where I know there is at least 2. =COUNTIFS({Rx Consumer Complaints Tracker Range 1}, HAS(@cell, $[Primary Column]$45), {Rx…
-
COUNTIFS not working correctly with dropdown critierion
I am using the following formula to count the number of rows that have both [Pricing] unchecked and [Status] showing any other value EXCEPT "Not Applicable. =COUNTIFS(Pricing:Pricing, 0, Status:Status, <>"Not Applicable") When I use the above formula, it keeps showing the incorrect value. I've filtered the sheet using the…
-
Formula to Refresh ONLY if Status is Open
Hi all! First of all, thanks for your assistance. I have a sheet, and I want to create a formula to another (a simple VLOOKUP). However on my initial sheet where the formula resides it will be based on the Status. If the status is Open, I would like the formula to make any updates. However if the record has a Closed…
-
Months Remaining Formula
Trying to come up with a formula to calculate the duration of contract between 2 dates regardless of todays date with a result in months. Then, how do I get the remaining months on the contract from todays date - in months - over multiple years - and if the start date has not began yet.
-
IfError- should this work?
I Am trying to get an IfError formula to work and not having any luck. CAn anyone help? =IFERROR([Product Type]@row = "Hardware", [Actual Shipment Date]@row >TODAY(-12), [Backlog @ Bud]@row), " ") I want that if a row is hardware and the actual ship date is not within the last 12days it populates the cell with the value…
-
Sum Child Rows when "children" are a different column
I am sure this has been asked before, but I can't seem to figure out a solution that will work in my sheet. I am trying to sum the child rows of a specific column, but my formula isn't working. Can someone take a look at the screenshot and see if you can help? I need to add the individual expenses (in the Expense Total…
-
Concatenate Name if Preferred Name not blank
Hi, I am trying to create a formula where I can concatenate a person's name as "Smith, John" if they don't have a preferred name listed (if blank) and as "Smith, Jane (John)" if they do have a preferred name. My fields are Last Name, First Name, and Preferred Name. Can anyone help? Thanks so much!!!
