-
Formula for non-duplicate values
Hi, Is there any formula to populate only 1 value of each value listed [Column1]? I.e., column 1 has something like the below, 45 56 45 55 55 56 46 56 Is there any formula to only show the below? 45 46 55 56 Thank you!
-
Setup Logic for Greater than 18 months
Need to create logic to check the archive box if a project is in a 'Not Started' or 'On Hold' status >18 months from the Submission date (system generated column). Triggered monthly by when the current month is > 18 months from the Submission date. The checked box will then flag the row to be moved to a new sheet to beโฆ
-
#INVALID DATA TYPE issue in SUMIFS formula caused by blank dates
I have a SUMIFS formula that I use to calculate monthly dollar amounts from another sheet. I know I'm getting #INVALID DATA TYPE due to blank date columns in the source sheet. I think perhaps an IFERROR formula might take care of the issue but I cant get it formatted correctly. Current Formula. Returns correct result asโฆ
-
Need help with a formula.
I need some help with the following formula. =INDEX([Phone 5]:[Phone 5], COUNTIFS([Phone 5]:[Phone 5], NOT(ISBLANK(@cell)))) The formula works until there is no result in the column. The error I'm seeing is #INVALID COLUMN VALUE. Is there a way for this formula to return "" when no results are found? I've tried a lot ofโฆ
-
COUNTIFS incorrect argument set
Hello, I am looking to gather metrics from a sheet of QC submissions. I have a very limited understanding of formulas but have managed to put together something that works through looking at examples on here and the tutorials. I have had success with the following formula counting the number of submissions of a certainโฆ
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There areโฆ
-
NETWORKDAYS formula with future dates
Hi, I am trying to work up a NETWORKDAYS formula to calculate "Days Active", either calculating between the Approved Launch Date and Close Date, or Approved Launch Date and TODAY(), if the Close Date cell is blank(basically, stop counting the days once the close date is entered). I managed to use the following:โฆ
-
Using entire columns to create dashboards in lieu of cells
I am tryin to create a dashboard that tracks a trend over time (weeks). It is pulling from a sheet where we document production week to week. I'd like to create a dashboard that will pull from the entire columns so that when I add future data it will automatically pull into the dashboard. So far it seems that I have toโฆ
-
Index/Collect #INCORREECT ARGUMENT SET
We have a formula error I just can't seem to correct. I want to return an abbreviation in column "CaseType" based on the value in column "Petition Type" I am using the following formula: =INDEX(COLLECT({Petition/Case Type Matrix Range 5}, [Petition Type]@row, {Petition/Case Type Matrix Range 2}, 1,)) References:โฆ
-
Formula Help Subtracting a Day
I have a networkdays formula that i need to have subtract 1 day because it is counting same day efforts as 1 day and i need it to count it as 0 days. How should i update my formula? =IFERROR(NETWORKDAYS([Actual Start Date]@row, [Sub-Task Completion Date]@row), "")