Formulas and Functions

Archives for October 2018

Discussion List

  • IF function with many conditions
    In Formulas and Functions
    I have an internal client who wants to parse a list of 100 different zip codes, and depending on the zip, assign another text field into a different field. In other words, IF zip code = 11733 OR 11725 OR 11890 (and so on) THEN assign to N…
    13 3
    13 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Vlookup
    In Formulas and Functions
    Hello,  We have here 5 different sheets containing records for Medical service details, including columns for patient name, ID, DOB, charge amount, payment status, etc. Now i want to get a sixth sheet that will look up from the above 5 s…
    65 6
    65 views 6 comments Most recent by Mike Wilday Formulas and Functions
  • COUNTIF formula
    In Formulas and Functions
    I am trying to count the number of projects completed between July 1, 2018 and June 30, 2019 with this formula:   =COUNTIFS({Status}, ="Completed", {Completion Date}, >=DATE(2018, 7, 1) <= DATE(2019, 6, 30)) The outcome …
    7 2
    7 views 2 comments Most recent by hennarizvi Formulas and Functions
  • Trying to count multiple people in a cell
    In Formulas and Functions
    I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked.  I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard.  I am using the formula: =COUNTIF({Project L…
    1593 26
    1.6K views 26 comments Most recent by Andrée Starå Formulas and Functions
  • IF / OR Formula help (#Invalid Column Value)
    In Formulas and Functions
    Hi everyone, I am trying to figure out a formula, that will show the following result: * If the completion date is before the due date, the green circle appears; or * If the completion date is after the due date, the yellow circle appear…
    142 9
    142 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • COUNTIF with Parent rows only, exclude children
    In Formulas and Functions
    I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status…
    1283 3
    1.3K views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Count values in a column or Pivot table
    In Formulas and Functions
    Hello, I don't have a pivot table app so I am looking for formula help.  I have a grid that has a column called "Goal".  Users and choose a value from the drop down or type in their own value in this field.  I need to be able to…
    280 7
    280 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • Separate Data
    In Formulas and Functions
    Does anyone know how do you split data in one cell into multiple columns?
    4 1
    4 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Hierarchy tagging
    In Formulas and Functions
    Greetings,    I have a organizational structure that has three levels * Campaign * Project * Deliverable * Task I am trying to figure out a way how I can have a column with one of the above values that is based on hierarchy. I have the…
    120 1
    120 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Overall Average Percent Compete
    In Formulas and Functions
    Hi All,   I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initi…
    1245 12
    1.2K views 12 comments Most recent by Andrée Starå Formulas and Functions