-
Formula that counts # of incidents across a date range
I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year. Right now the formula is =COUNTIFS({Incident Type}, [Primary Column]@row) but this doesn't take the date range into consideration. What should…
-
Using Formula for a total count/sum
Thank you for taking my question. What is the format to create a formula that supports this scenario; A total count or sum based on a specific word in a cell in a sheet. For example, collect the total number of the word "Pass". Same for "Fail" and so on.
-
Creating a formula to calculate percent from the parent rows
I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The parent rows are currently averaging the percent in the sub rows below it. In this case, I want the total percent to be in…
-
Can you combine the criteria of formulas?
Hi, I'm looking to input a formula to a sheet which will count the number of "Open" residual risks that are also recognised as 16 and above. I already have a column for the number of Residual Risks scored 16 and above and a separate column counting the total number of open risks on the entire sheet. Is there a way to make…
-
Returning Non Duplicates when comparing two Multi-Select Columns
Dear Community Is this possible in Smartsheet? I just can't seem to return what I need! I've been playing with Join(Collect()) type statements but maybe I have overcomplicated it! Scenario and requirements are explained in the screen shot. Happy for you to say Column 1, Column 2 and Column 3 in any suggested formula, as my…
-
Index Match not working with multiple options
I am trying to get a formula to work with multiple options selected in the reference sheet. The reference sheet has a Unit column and multiple contact columns. The contact columns are based off the roles within the unit. I have several formulas based off the Unit column. Some units have the same contact list, so I have…
-
RAID Log - Numbering
I have a column entitled 'RAID' with dropdown options: Risk, Action, Issue, Decision, and a column entitled 'Auto' which is a column type Auto Number starting at number 1 (no prefix or suffix). This Smartsheet has a form. When a user completes the form, they will select 1 of the 4 RAID drop downs, they submit the form and…
-
Project Plan Reports
Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible? If not, is there a formula that pulls the task name that I can…
-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
