Discussion List

• Tasks Within a Date Range Formula

  In Formulas and Functions

  Hi, We meet weekly with a client to show all the tasks that have been worked on since the last meeting (7 days ago). So I am trying to create a Report to show this. Could not get the report builder to filter this exactly as it never captur…

  Brandon Good

  04/02/20

  Accepted

  315 7

  Answered ✓ 315 views 7 comments 0 points Most recent by Paul Newcome 04/02/20
• Help with ISBLANK & ISDATE syntax

  In Formulas and Functions

  I made a checkbox helper column. I want the box checked if an "install date" is a date and is between 14-21 days, AND "Submitted For Order" column is blank. Here is the formula i have =IF(ISDATE([Install Date]@row), IF…

  steve50951

  04/02/20

  Accepted

  145 3

  Answered ✓ 145 views 3 comments 0 points Most recent by Paul Newcome 04/02/20
• Contains formula not picking up text

  In Formulas and Functions

  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

  Liam Burnett

  04/02/20

  Accepted

  165 10

  Answered ✓ 165 views 10 comments 0 points Most recent by Liam Burnett 04/02/20
• COUNTIFS on multiple columns looking for multiple conditions.

  In Formulas and Functions

  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". …

  jambla

  04/02/20

  Accepted

  38 3

  Answered ✓ 38 views 3 comments 0 points Most recent by Andrée Starå 04/02/20
• Using COUNTIFS for multiple criteria

  In Formulas and Functions

  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…

  Lindsey Crabtree

  04/02/20

  Answered - Pending Review

  579 6

  Answered - Pending Review 579 views 6 comments 0 points Most recent by Paul Newcome 04/02/20
• COUNTIF - FINDING MULTIPLE VALUES IN 2 COLUMNS

  In Formulas and Functions

  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 …

  Donni Matthew

  04/02/20

  Answered - Pending Review

  157 1

  Answered - Pending Review 157 views 1 comment 0 points Most recent by Paul Newcome 04/02/20
• Building a Sum If Statement

  In Formulas and Functions

  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 …

  Kasey Bernard

  04/02/20

  Accepted

  13 5

  Answered ✓ 13 views 5 comments 0 points Most recent by Paul Newcome 04/02/20
• Dynamics metrics across new sheets

  In Formulas and Functions

  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 …

  BHannah

  04/02/20

  Accepted

  87 3

  Answered ✓ 87 views 3 comments 0 points Most recent by Paul Newcome 04/02/20
• COUNTIFS using 2 colums

  In Formulas and Functions

  I am trying to return a count of how many active cardholders had their cards for 12 months. I'm using this formula and it keeps returning a value of 0. =COUNTIFS([Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUNT", Tenure:T…

  Darla Brown

  04/02/20

  Accepted

  12 11

  Answered ✓ 12 views 11 comments 0 points Most recent by Paul Newcome 04/02/20
• Nested If Statement

  In Formulas and Functions

  Can someone help me correct my formula? I'm getting a #UNPARSEABLE error. =IF(AND(TODAY() > [Intranet Due Date (SA- Date to Complete By)]1, Status1 = "Completed"), "Completed", "Past Due"), IF(AND(TODAY()…

  Nelson Truong

  04/02/20

  Answered - Pending Review

  21 1

  Answered - Pending Review 21 views 1 comment 0 points Most recent by Debbie Sawyer 04/02/20