-
Remove formulas in data shuttle
Data shuttle does not allow formulas to be turned off so when I upload an excel file in data shuttle, my numbers are being rounded.
-
Sumifs with criterion range in column with multiple entry options
I track all of our projects on a single sheet, to include opportunities and finished projects. I want to sum the total sold amount. I have a column called "project status" that has 11 options for various status descriptions (i.e. pipeline, proposed, awarded, booked, complete, etc.). I'm trying to use this column as the…
-
Counting rows from another sheet that meet a specific criteria
Hi All! I'm trying to count the amount of rows from another sheet that meet the following criteria: All rows that are within the "Quality Control - Bioassay" department, that are not closed nor cancelled in the status column and the creation date is less than 30 days, then less than 60 days and then more than 90 days…
-
Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
-
JOIN(DISTINCT(COLLECT + JOIN(DISTINCT(COLLECT but how to remove duplicates due to using two formulas
Hi all, First post but I've been reading (and making use of!) many of the queries & answers for a while. Stuck on this one! I have two JOIN(DISTINCT(COLLECT formulas that I am adding together, but sometimes the same person's name will appear twice due to being pulled through by both formulas. How do I prevent this type of…
-
First Entry Flag equation as column formula?
Good morning! I'm trying to create a flag in my form receiver sheet to identify first entries vs. duplicates. This is to help me pull some metrics (counts) in other sheets. I have an equation that works row by row, but not in the very first row and also can't be converted to a column formula. What am I doing wrong? I'd…
-
I am trying to create a formula with varying conditions
I am trying to create a formula for the likelihood of a project. I have 2 helper columns and a final column. I am only worried about 1 of the helper columns as I cannot get it to work. The Conditions I am missing is for when a project is planned to start in the middle of a year, I want the % to carry over until 0, and…
-
Reference EACH child from the Parent on Another sheet
I want to display (from another sheet) the child rows. How can I use a formula, on each of my child lines that displays child1, child2, child3, child4, and child5 in my Release Name & Release column. I only require the ability to do this in these 2 columns. The black text is raw data (and the blue text are formulas).
-
Can I get help with a SUMIF formula for a Sheet Summary?
Is it possible to SUMIF a $ value column, based on a "this month" check box in Sheet Summary? I', using [Value]:[Value] and [This month?]:[This month?] for my columns. Thanks! Jen
-
Combining countifs and countif into one formula
Hi all, I have a sheet which includes two separate formulas, one, a "countifs" and one a "countif". Both work seamlessly in their respective columns. However, in reviewing my related dashboard, I noticed that my "countif" column was including a row of data it shouldn't and realized that I needed to amend my "countif"…
