-
The Average Number of Monthly Projects
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?
-
Sequential Unique identifier for two types of records in a sheet
Hello Smartsheet community. I am in need of a solution that allows me to leverage an intake form to track Objectives and Key Results. I need to be able to sequentially generate unique ID's for each Objective and for each KR and I need this to not break with sorting. The reason is, I need to do lookups on the Unique…
-
=SUMIF Formula
I'm looking for some guidance with this formula. I can't seem to get the numbers to add up if the condition is met. Essentially if the cell is "No" a number should be added and the number is different based on the column. Those numbers should then be added for a total. Here's what I'm working with... =SUMIF([Column]1 =…
-
#INCORRECT ARGUMENT SET in Nested IF statement
Hey All, I think I have all my ducks in a row here, but I continue to get a #INCORRECT ARGUMENT SET Error. Trying to dynamically set a status indicator. Can someone assist? For more info: [Assigned To] is a Contact List [Resolved] is a checkbox =IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 0), "In Progress",…
-
Contains formula not picking up text
Hi, I have this contains formula that searches for M&E and im not sure why its not working. Could someone please point me to where im going wrong. Thanks, Liam
-
COUNTIFS on multiple columns looking for multiple conditions.
Hi, Im trying to count how many rows fit a specific criteria. Here is my example table: In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A". This is my formula: =COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status],…
-
Using COUNTIFS for multiple criteria
I wanted to count the number of TASKS that have a STATUS <> Complete where the FINISH date is <= TODAY and I have that formula: =COUNTIFS(Status:Status, <>"Complete", Finish:Finish, <=TODAY()) Now I want to add Assigned To into this equation. So I want to count the number of TASKS that have a STATUS <> Complete where the…
-
COUNTIF - FINDING MULTIPLE VALUES IN 2 COLUMNS
I am trying to write a formula that will count 2 values in one column & exclude two values in another column. My two columns are: Department & Modified. I want to count the words "Sale" and "Manager" in this multi-select column but only if the Modified column doesn't contain "Furlough" or "Separated". I tried:…
-
Building a Sum If Statement
I'm trying to build a SumIfs statement that calculates the number of hours by type (Sick, Vacation, Personal) by employee ID. I'm able to do a simple SimIf for the total, but struggling with how to break it down by sick type. This is the statement I'm using and its resulting in an incorrect argument: =SUMIFS({Employe…
-
Dynamics metrics across new sheets
Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace. For example: KPI=Number of late deliveries across all projects at a client I can create a metrics sheet and create a formula to pull data across sheets, but each time a new project is started, I would…