-
How to return the most recent text for a given value?
How can I return the most recent text from a cell, setting a criterion? I tried to use the formula =INDEX(), MATCH() -1, I understood that the "-1" in the formula would return values in descending order, but when I apply the formula the column repeats the same value found in the cell where I applied the formula to the…
-
I want to populate a Quote with information from a price list sheet
Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU / Stock code into the quote and have the…
-
Need to assign an ID between 1-20 but cannot duplicate any numbers.
We have a license sharing system (allowed to share by the user agreement), that we are currently manually assigning IDs that are not in use, but I want to automate the process. Basically, the function should look at the ID column and assign any number between 1-20 that is not currently in the list.
-
SUM multiple values in 1 column when 2 other columns have specific values based on unique ID
Hello! I am not a seasoned user and have been unable to find a solve for my function issue. I have sheet 1 (Request pdf) that is populated by a form. Employees request funds and can have more than 1 entry. On sheet 2 (allocation pdf), each employee has a set number of funds available. I want to add all of the $ requested…
-
Is there a way to copy certain cells from one SS to another without creating new row?
I have a project that I am managing in SS. The customer also has the same project they are managing in SS (their own domain). I have admin rights to both, but my admin rights in theirs is assigned to my gmail, whereas my sheet is assigned to my company email address. They need to see only certain information from my sheet,…
-
Average values assigned from health ball forumulas
We need to average 4 columns that utilize Harvey balls to determine an overall project score. We added helper columns with a column formula that would assign a value to each rated criteria (budget, time, scope, quality): =IF(Budget@row = "Blue", "5", IF(Budget@row = "Green", "4", IF(Budget@row = "Yellow", "3"))) Is there a…
-
using a COUNTIFS formula and @row
Hello I have a cross sheet formula grid, where i am trying to count multiple ranges and multiple criteria. My formula is =COUNTIFS({Group}, "Playout", Show@row, {Action}, "All Call") and I get an Incorrect Argument Set error The 'Show@row' piece is meant to not have to do individual formulas for over 130 shows. I'd like to…
-
Pulling information from second sheet based off one criteria and and if it falls between two numbers
I have one sheet that has job title, salary and then a column called Thirds location where I want to pull in information from another sheet and have it say lower third, middle third or upper third. On the other sheet I have the salary ranges and then broken into thirds. For example, For sally Gold, I want to reference the…
-
SUMIF Function- exclude what has been completed
Hi, I am trying to create a formula that shows how many pieces of art (POA) have not been completed in a given month and that have been completed in a given month. Here is my table below. I am currently using this formula to sum how many POAs would be completed in a given month. FORMULA: SUMIFS({High LevelArtwork Status:…
-
Formular for calculating total amount for each department by month, this week, last week and a day
Hi Guys, I'd like to create a metrics that calculates an amount for each department by this year, last month, this month, this week and last week. Btw i will be refrerencing from another sheet "Sheet - Transport Request". Can you guys help with a formular? Technically, I need help with 4 formulars. I'm sorry if I am not…
