-
Link 2 sheets
I have a webform filling in data onto a plain grid sheet. There is a column on there that has a drop down for Assigned to, and there is a column for Client name. I want to be able to transfer this data from these 2 columns to fill out another sheet. So if a job for Metricon Homes is assigned to John Smith in one sheet,…
-
Form Submission creating new row - cant do notification
I have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. The last 6 columns are meant to be fixed (content doesnt change). So when a new form…
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
COUNTIFS @row Resulting in 0?
I am using a countifs function to determine if we have duplicates in an invoice tracking workflow. I am confused because some rows return a 0 result, where all rows should at least show 1. Any ideas? =COUNTIFS([Invoice Number]:[Invoice Number], [Invoice Number]@row, [Vendor Name]:[Vendor Name], [Vendor Name]@row) It should…
-
Countifs and Multiselct Cells
Is it possible to use a Countifs function with multiselect columns? I have a column for Geographic Market where the options are BOS, SF, SD. It seems my formula is only counting the instances where "BOS" occurs by itself not when it occurs in the same cell as "SF" or "SD". =COUNTIF(Market:Market, "BOS") What do I need to…
-
Alpha order
I have a list of sites that I need to break up in alpha order meaning that I need to see sites that only start with the letter of the first word of that site. Is there a formula for that? I'm going to create a directory portal so that when a person clicks on any letter of the alphabet, they only see the sites starting with…
-
Calculating the Year, Month, and Days for Tenure
Hello, I am attempting to calculate tenure in years, months, and days given the total # of days. I calculated the # of days between hire date and term date in 1 column (# of Days), and used the formula below in another column. It is not calculating correctly, and I am getting decimal numbers for the months and days…
-
Countif statement using two sets of criteria
I am attempting to find the number of "Tactical" cells within a specified date range. I am receiving an error UNPARSEABLE. =COUNTIFS([Date Presented to FRB]192:[Date Presented to FRB]207, MONTH(@cell) = 4), + COUNTIFS([Force Level_FRB]:[Force Level_FRB] = "Tactical")
-
Count Number of rows based upon multiple Criteria
Here is my problem: I have 6 columns that may contain a number (score), if they all contain a number (score) they will sum into column 7 for a grand total. In some cases not all of the original 6 columns have a number (score) and I want to count how many rows are missing a score. I already have formulas for count with…
-
Countifs
Hi, I am hoping someone can help me. I am trying to count the number of "dates" in one column, compared to how many "dates" are not entered in another column. So for example, Column A has 15 dates in it and Column B has 5 dates in them. I'm looking to determine out of the 15, how many don't have a date - which would be 10.…
