-
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
-
Formula Help!
I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with: I need to search one column of information for any input values for only the past two weeks IF a…
-
COUNTIFS and Date Range
Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/04/2019 to 30/04/2020 =COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2,…
-
COMPARE COLUMNS
Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false) and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1) But i only…
-
Formulas for Column Dates to Autofill
Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to figure out how to set it up so that the Project Auditor Completion Deadline will auto…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…
-
VLOOKUP/IF or INDEX/MATCH?
Hello, I'm not sure which combination of formulas I require (VLOOKUP, IF, INDEX, MATCH...) In sheet 1 I have the columns "resource name" (text) and "onboarding paid?" (check box) In sheet 2 I have the columns "resource name" (text), "onboard?" (check box) and "milestone paid?" (check box) If the resource name matches, AND…
-
Sheet Summary - SUM Chilldren Rows based on Status and Dates
Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). I tried applying the following formula before involving dates to make sure the first part of logic is correct but it is giving me an…
-
Date Range Formula
Hi, I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with this? =COUNTIFS({Citi Table Change Tracker Date Submitted} >= DATE(2019, 1, 1), {Citi…