Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Tasks Within a Date Range FormulaIn Formulas and FunctionsHi, 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…
-
Help with ISBLANK & ISDATE syntaxIn Formulas and FunctionsI 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…
-
Contains formula not picking up textIn Formulas and FunctionsHi, 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.In Formulas and FunctionsHi, 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". …
-
Using COUNTIFS for multiple criteriaIn Formulas and FunctionsI 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…
-
COUNTIF - FINDING MULTIPLE VALUES IN 2 COLUMNSIn Formulas and FunctionsI 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 …
-
Building a Sum If StatementIn Formulas and FunctionsI'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 …
-
Dynamics metrics across new sheetsIn Formulas and FunctionsGoal: 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 …
-
COUNTIFS using 2 columsIn Formulas and FunctionsI 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…
-
Nested If StatementIn Formulas and FunctionsCan 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()…