-
Count all cells in a column that are NOT blank and do NOT contain a date
Hi, I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.
-
Flagging task if not updated
Hi, I have a sheet that tracks a group of teams' weekly KPI's. Each week on a Thursday, the different team members need to access their sheet, update the date that their KPI's relate to and enter the KPI's for each line. Each team has a separate sheet that rolls up into a "AT RISK" task tracking report for me. I have to…
-
Counting a date diffrence with children
Hello, Does anybody know if there is there a way to make the below formula work? I'm not sure what I'm missing. I need a count of children where the difference between the task due date and the created date is 1 or less.This one has stumped me. =COUNTIF(SUM(CHILDREN([Due Date]8) - CHILDREN(Created8)), <=1)
-
Countif referencing another sheet not working
I have a column in another sheet called Ranking (Text/Number field). It contains numbers from 1-200. Using this formula it's returning a value of 0 which is not accurate from the column I selected. Is there something I'm missing? =COUNTIF({Ranking}, >100) I even tried to complete the formula in the sheet directly and it's…
-
Help index and match?
Hi: I have a sheet (target) which has a project ID. I have another sheet (source) with 100 columns (which has the project id) I want In the target to take about 20 fields from the source and put into the target. Vlookup is limited as it can't handle more than 20 columns. and I can't find an example MY field is called…
-
Some Results are not showing from my formula
=IFERROR(SUMIFS({# tags}, {TaggedBy}, Employee1, {QAedCebu}, MONTH(@cell) = 10), " ") Formula Breakdown: (Reference Sheet A contains all tags, dates and employee assignments, Sheet B is the sheet I am trying to create totals on) # tags = Number Column (ref to sheet A column) TaggedBy = Employee Name Column (ref to sheet A…
-
COUNTIFS on 2 check box columns, 1 checked, 1 unchecked
I am trying to write a formula for a sheet summary where an "Over Due" check box is checked (driven by a due date column), and a "Done" check box is not checked... =COUNTIFS([Over Due]:[Over Due], 1, Done:Done, 0) #Invalid Operation... I originally tried to run a countifs based on Done = 0, and Due Date < TODAY, but…
-
Enhancement Request: Allow "when condition is not met" for Date columns
In order to do some common date related conditional formatting (for example, aging or older than 7 days ago https://community.smartsheet.com/discussion/setting-conditional-format-when-date-eg-more-week-ago), we need to create a formula. This could be avoided if we had the same functionality for dates that we have for other…
-
Checkbox and IF statements
Hello having trouble creating a formula and not sure if it is possible So I have two sheets first with 5 check boxes and then a value field. The second which holds the values. I want to be able to check the boxes and then have the value field add up the total example Sheet 2 values = These values might change over time…
-
Count projects that will complete in the current month - parent rows only
I have a sheet that houses all projects within one department. Many of the projects have child rows that I don't want to include in my count formula. I have a Hierarchy column that reflects "0" in the parent rows - those are the only rows I want to count if the date of completion is in the current month. Help? Thank you!