-
Formula need to separate mixed text from a single column into separate columns
Using the LEFT or RIGHT formula currently as a means to separate the [Sales Rep Info] column. Problem is I can only figure out how to do it by number of characters. I need the formula to separate first and last name into a new column and a second formula to capture the information in the parenthesis. Same for the [Customer…
-
Finding Distinct Values in Two Columns
Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am getting 1 as my output here? Is there any other way I can accomplish this?
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don't want every person listed on the source sheet added to my formula sheet. I need a…
-
Calculating SLA based on time/hour formula
Hi @Paul Newcome I thought I would write a new thread and @ your name on this post. Hope thats ok. Taking this from Formulas for Calculating Time thread. --------------------------------------------------------------------------------------------------- @Paul Newcome What a thread! Came across this when I was looking for a…
-
Check for Duplicates and Blanks
I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple blank rows). I'm using this for an automation script in a column formula to have all…
-
Sumifs Formula with a Contain
I am trying to get the sum of hours worked IF the "Office" Column = Administrative Solutions. The Office column is a multi-select dropdown. =SUMIFS({Project Intake with Form Range 1}, {Project Management Tracker- Discovery to C Range 9}, CONTAINS("Administrative Solutions", @cell")) Any help would be appreciated! Thank you!
-
Cross-Sheet SUMIFS is returning #UNPARSEABLE
Hello, I'm having an issue with a cross sheet formula. I'm trying to build a budget tracking system in two parts. It involves a top sheet with a the sum of all expenses by category and an expense log that is a running list of expenses. I tested the following SUMIFS in the expense log and it works correctly.Where it is…
-
COUNTIFS and AND
Hi there! I am trying to insert a formula that reads two columns from another sheet. I want to count the cells if one column equals the Primary column name in my new sheet and the other does NOT equal the status "Scheduling Complete". I can't figure it out! Below is what I currently have and have tried dozens of…
-
Referencing 2 ranges in another sheet
Hi all, I'm trying to use data from another sheet to get a count. I have 2 relevant columns in the reference sheet, Name and Date. I'm trying to count the number of dates for a given name in the last 30 days. Here's the formula I'm trying to use: =COUNTIF({Hiring Actuals Range 1}, ="Smith, John", {Hiring Actuals Range 2},…