-
=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",…
-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…
-
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…
-
Having multiple paragraphs in one cell for Approval Request
I'm trying to use Approval Requests for something and some of the columns are analysis's and are written in paragraph form. This is a formal process and I want it to look as professional as possible. Even though in smartsheet I can use Ctrl+Enter to add a space and create a new paragraph within as cell, when it is sent in…