-
Counts if with multiple conditons
Help! Trying to get a count if line items that do not have a column marked resolved and have a issue type of Reports Missing. =COUNTIFS({Aimbridge Report Issues Range 2}, "Reports Missing",{Aimbridge Report Issues Range 2}, 0) I am sure it is simple...but I an not figuring it out and need help!
-
Countifs using iferror or iserror
Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've been…
-
Formula help for my dashboard
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to select…
-
Budget Sheet YTD Sum formula help
I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel) Each month has 2 columns Actual & Budget, i want to set up a formula so when numbers are entered into respective monthly cells the YTD cell…
-
COUNTIFS to count when a cell contains any version of a word I want to count
How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?
-
COUNTIFS | 2 CRITERIA FROM SAME COLUMN | REFERENCE SHEET
Kind Sir/Madam, Greatly appreciate any help on the following: I created an extra sheet with formula's so I can have them displayed in a dashboard without having to add all kind of formulas and outcome of these formulas in my source sheet. My goal is to count the number of "approved" and "completed" quotations (same column)…
-
DISPLAY BOTTOM ENTRY ON A COLUMN
How can I display the bottom (last entered) value of a column in a different "cell"
-
Wanting to count dates within a column
Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column. Thoughts? Thanks! Shannon
-
Exclude summary row from count
Hello, How do I exclude the summary row in the following formula? =" Yellow: " + COUNTIF(Risk:Risk, "Yellow") + " Red: " + COUNTIF(Risk:Risk, "Red") Basically, the summary row RYG ball risk indicator should NOT be included in the risk count of the child rows because it causes a count that is one higher than the actual…
-
Trouble with formulas not applying to new info coming from forms
I created a form to capture data into a sheet. i have the form sending new info to the bottom of the form. when the data comes in from the form it puts the rows below the formulas, so the formulas are not applied. It's a sum formula, so i need it to capture the total amount of totals coming in from the form. how do i get…