or Explore Discussions

# 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