-
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…
-
RACI - 2 in 1 Event sheet - template usage
I'm having trouble understanding the template - and can't find directions for how to use or specifics on the formulas used - which are huge...so the T- # is what is confusing me. Any directions or assistance would be great.
-
Nested IF statement with date comparison
I am either getting a #UNPARSEABLE error or #INCORRECT ARGUMENT with my formula. I am trying to compare two different date columns (Posted Date) or (Last Reviewed) against another date column (Deadline) to indicate a Yes or Review Needed. One of my columns (Last Reviewed) could be blank because it has been reviewed since…
-
I need assistance with a parent/child formula
I would like to return a specific value in a parent row when all the values of the children is equal to a specific value. I would like the parent row to automatically show complete as soon as all the children rows are completed. The cell can be blank if all the values are not complete. I used the following formula to get…
