-
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!
-
Formula Help!
Hi there, Would someone be able to help me with a formula that would be able to calculate the Fiscal Year based on a Finish Date of a project? FY19 - Feb 2018 - Jan 2019 FY20 - Feb 2019 - Jan 2020 FY21 - Feb 2020 - Jan 2021 Thanks so much!
-
COUNTIFS and/or IFS help needed
Here is my situation: I have a PMO tracking sheet that is tracking many projects through various statuses. I am putting together a metrics sheet so I can create charts to put on a dashboard. In the metric sheet I am trying to count the number of projects by department where the status is not Complete or Cancelled. I can't…
-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…