-
Multiple IF statements
Hi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out. In my PRICE column if have the following formula. It works for the "Chair" category but nothing else. Any guidance is appreciated.…
-
#INVALID VALUE Error - Can't figure out why...
I am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH(Auto@row, Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amount: Text/number column =INDEX({Job Tracker Invoice Amount}, MATCH([Invoice Number]@row, {Job Tracker…
-
how do i import multiple large googlesheets, with multiple worksheets, and then integrate them?
Hi, I have inherited several google worksheets. each worksheet is stand alone, with about 20+ workbooks per sheet. the first several workbooks of each sheet are basically summary dashboards of the remaining workbooks. so there's lots of vlookups, sumifs and so forth. When I try to import, of course only the first sheet of…
-
Formula to fill multi-select from a join of other columns?
Hi, See my use case below. I'm using columns as shown in (1) for users to identify which documents are required per category (rows). I use simple formula columns in (2) to get the appropriate text. My target is a formula which yields a result as (3). However, I don't know how to do it and end up with (4) which just…
-
Need help with buried IF statements.
I need help with a formula that I think will have multiple IF statements. Please see below. I am trying to determine the Maint Tech YTD Score. For the formula, we will only be using the "Community Average Score", "Company Wide Satisfaction Avg.", and the "Score Delta". We are comparing the Score Delta to the Company Wide…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!
-
Reference an entire column and sync it with another column in a secodn sheet
Looking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.
-
Can I erase a reference name and reuse the reference name for another range?
Can I erase a reference name and reuse the reference name for another range? It looks like once I use a reference name and mark the range, I can't erase the name and reuse the reference name for another range? it will indicate the name already use on this sheet even I deleted this reference name? Is there a search function…
-
IF formula from multiple cell information
I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to do the colored circles at the beginning of the row. Would do gray if the column is…
-
Is there a limit per sheet on the amount of cells that formulas are applied?
Hello, Is there a limit per sheet on the amount of cells that formulas are applied? I know there are other limits, like cell linking and the amount of rows on a sheet (5000). But as far as formulas?