Countif
Discussion List
- Hey everyone. I am looking to count the number of projects assigned to an individual with the status of not completed. I am referencing another sheet for the formula. Here is what I came up with. And …
How can I calculate the number of years between 2 dates where each calendar year must count as 1 yr?
I need to calculate the number of years between Contract Start and Contract End, where the years must be counted as whole if they are within a calendar year? This calculation is being used to create P…
- Currently there is no way to capture and report the number of rows in a report (or across multiple reports). It is common in dashboard reporting to create a metric (or card visual) to count the number…
- I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working per…
- I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options. For example, in Column B, I have following look up values …
- Hi, I think I'm close but I can not seem to get this formula right, so coming to the big dogs for help :) This is my refrence sheet, and I'm trying to create a data sheet to collect the numbers & disp…
- Hello, I am new to smartsheet and trying to create a dashboard for my source sheet. I have created a blank sheet to help add all my formulas. 1. I have a source sheet - "MySheet" 2. It has a "Category…
- I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the…
- I am working on a sheet where I want the parent rows to reflect the health status of their child rows. I have defined four categories, which are "No Risks," "Some Risks," "Overdue / Risks," and "Cance…
- Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these …
