-
Auto Add a Number After Auto Numbering
I have a master sheet which captures data and assigns an auto-number (Incident Number). When a row falls into a certain category (Warranty), it gets copied to a new sheet. I want to be able to take that unique Incident Number and add to it. This is what I have so far: It puts a prefix onto the Incident Number, but I also…
-
How can I update a checkbox on a sheet based off of criteria from another sheet?
I'm trying to update a checkbox on a sheet based off of criteria from another sheet. I've seen several examples using the INDEX / MATCH function but haven't had any luck because the situations seem to be a little different than mine. Here is my situation: Sheet 1: Time Tracking - updated by each employee each week via a…
-
If, Index & Collect Formula issues
I have an issue with my current If, Index, and Collect formula. I have two sheets. One for data collection, and another for the Reviewer's Agency, Schedule, and Email address. I want to automate this process where if I have a TFD C shift, the Reviewers email address will be added into the data collection sheet. Here's my…
-
COUNTIF as of Today?
Hi, I have a sheet I'm using to calculate the number of open tasks on my project. =COUNTIFS({Corporate MOC Location}, CONTAINS("BER", @cell)) The reference sheet is constantly being updated as and when actions are completed. I want to cell link this count to my KPI sheet to track the performance of the team over the course…
-
VLOOKUP not pulling in correct data when duplicate names
Hello I have a line of business with three choices: deploy, consult, and managed services, each associated with all theaters. When someone submits a request through the intake form, they select one of these options, and the form populates the data into the Sub_Org column based on the chosen line of business, and theater.…
-
Can you pull between two times when using the countifs function?
When using the Countifs function, can you reference the created column (which includes both the date and the time) and pull based on submissions between certain times. EX: =countifs({Form Date}, TODAY() - 1, {Form Date}, "04:30pm:11:59pm")
-
How do I create a formula to pull the year from a date from every row in a column?
Hello! I am very new to formulas, and I'm having a hard time figuring them out. I want to create an automatic function that will pull the year (and separately, the month) into a new cell, so that I can break down my sheet into year, and then month, with collapsible rows. Basically, I have a row titled "Date of Employee…
-
If OR and SUM formula
Hi, I created this formula but I'm not sure why I'm getting the error message "INVALID DATA TYPE" =IF(OR(Name@row = "AB", "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))
-
Data transferring
I'm trying to transfer information from sheet one to sheet two, then update the information on sheet two, and then that information to be transferred to sheet one.
-
Seeking Assistance - Average Days Open, by Status, Month/Year
Hi All - I'm trying to calculate the average # of days for data set, where the Status is "X", and the M/Y = "Y". I'm good with "AverageIf" = label@row, but not sure how I can incorporate the date piece. Thanks in advance! Sharing some snapshots of the data, all columns (Total Days Open, Completion Status, Leave Blank...)…