-
Can't get all IF AND parts of formula to work
Hi, I am creating a multi-part IF AND formula. Basically, I'm looking at two columns: Product and State IF Product = Science, assign to Mike Foster IF Product = Mathematics AND State = certain states, assign to Paula Smith If Product = Mathematics AND State = other certain states, assign to Bill Peace I've come up with the…
-
IF/AND/HAS for 3 column references, 6 options
Based on the content above for reference only, the actual sheet screenshot below. I need a formula or help with a helper sheet/workflow, to bring back one of 6 results. (above image) Tax Status Column is a dropdown with the 2 options shown, Bottling Location and Entity Columns are INDEX(COLLECT formulas (if it matters)…
-
Calculating % of Yeses in child rows from Yes/No Column
I am looking to get a percent of "yes" in a column named "Yes/No" in the parent row. Example, I have a parent row with 5 child rows - 4 of the child rows have "yes" one has "No" I am looking to show the % of "Yes" in this case the result should be 80% with Yes. Thanks
-
Tallying Totals in Summary
=COUNTIF(Created:Created, YEAR(@cell) = 2023) Generates invalid data type Created is a autogenerated date time column when the row is created. example of format - I can get a single cell from the column to return 2023 using the Year() function but when using it in the formula above with @cell it errors. I feel like I am…
-
Formula Help! VLOOKUP searching through a multi-select dropdown
I keep trying different variations and can't find it right: The formula that I used which is close would be =VLOOKUP([Item ID Number]@row, {Adult Sponsor List Range 1}, 3, false). Sheet 1: giving tree wish list Sheet 2: the adult sign-up list I want for the adult email address (listed in sheet 2) to be looked up and added…
-
Formula to join cells from a contact list column while maintaining the contact list type for filter
An example would be to have a "Team Sheet" that has a column for "Team Dept." and another column for "Team members" that is a contact list type. In another sheet called the "Project Sheet," We'd have a column for the Project name, one for "Team Dept.," and then another for "Team Dept. Members." I'd like to use Team Dept to…
-
Automate Parent Row formula and keep children formula in place
I'm trying to figure out the best way to automate a formula specific to the parent tasks and keep the existing children formula in place. The goal is for the user to be able to add more parent/child tasks without having to insert the formulas manually. The parent formula in use: =IF(COUNTIF(CHILDREN(), "Red") >= 1, "Red",…
-
How to count individuals in multi-contacts separately?
I'm working on a formula for project allocation. I'm extracting my information from two columns in another sheet, master tracker. The columns from the master tracker are Status and Project Leads. In the sheet for Project Allocation, I'm using the following: The Columns are the Status and Person 1, Person 2, Person 3, etc.…
-
Index/Collect Formula Not Working..Incorrect Argument Set Error
I have two sheets. Sheet A is a rate sheet with the columns: CEB, Client Name, Client Engagement Name, Engagement Resource, Engagement Rate. Sheet B is my weekly billable time report with the columns: Quarter, CEB, Client Name, Project Name, Date, Hours, Employee, Description, Rate, Total Cost I want to pull over…
-
Parent cell return Data based off of Children Data
Hello, I am trying to figure out how to put the following into a formula: If values in any child rows include "In Progress" then populate parent as "In Progress", otherwise... If values in child rows do not include "In Progress" or Blank then populate parent as "Not Started". otherwise... If values in ALL child rows…
