-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
-
Auto fill column with value from first cell in another column
I have an application where I use a header row to collect higher level project information, like overall project status, project start and end dates (as opposed to task start and end dates), etc. I copy rows from individual project plans to an "all projects" sheet from which we do some PowerBI reporting. I need a column…
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
INDEX (Match) Formula with contact columns
Hello, I am using an INDEX(MATCH) formula referencing 2 contact columns and it works great. However, when I try to convert to Column Fx it will not let me. Can we not change contact columns into formula columns? Or is the fact I am referencing contact columns in my formula a problem? I am not referencing partial ranges.…
-
Show tasks completed in calendar week?
Is there a way to count the number of tasks completed in a calendar week, Sunday-Saturday? I have a metric that shows the number of items completed in the last 7 days (>TODAY(-7)) and I've been asked if the metric can show items completed in the calendar last week, meaning Sunday to Saturday, rather than a rolling last 7…
-
IF Formula with Multiple Criteria
Hi all, Working on an IF formula with 3 conditions. IF Value = 0, "No probability of Risk: Functionality requires evaluation and/or validation when/ if the functionality is intended for production use." IF Value, 2-36, "Low probability of Risk: No Computer Validation testing required." IF Value, =>36, "Medium probability…
-
How to write a formula with multiple conditions?
Hi, I have these 5 Phase columns in my project tracking sheet. Now i want to automate the column named "Test" that shows at what phase the project is currently in. The logic is something like: "If the Phase 1 is 100%, Phase 2 is 45%, Phase 3 is 65% then the project should be at Phase 2" Ideally if the phase is at 100%, It…
-
How to apply a priority countif formula to specific rows based on cell criteria?
Hello, I am using the following formula in a priority column to maintain ranking number when filtering my sheet. I would like to apply this formula to the rows based on criteria in my "Open, Backlog, Closed" column. For instance, if a closed is selected for a row, i do not want the formula to apply to that row.…
-
Generate Random Lists
Is there a function/formula that can take a list of names and randomly assign them to groups? Example: If I have 20 individuals that I want to assigned to groups of 4: Group A, Group B, Group C, and Group D Column 1 has list the names of the 20 individuals Column 2 is the output field for where the formula would go to…
-
I'm just stumped on this date function. Can someone help me please?
I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't…
