-
when nothing from Index/match
Hello, when there is no return from index/match, instead of marking it N/A, it randomly picks any value which making the match incorrectly. any tips? Thanks,
-
Date Formula Question
Hello, I am creating a formula to pull the month out and then if the date is blank to have the field be blank. Here is the formula I am using: =MONTH([Activity End Date]@row, IF(ISBLANK([Activity End Date]@row, " "))) However, I am receiving an "Invalid Data Type" response. I've attached a screen print. If the Activity End…
-
How would I create a formula which returns the Top 5 most frequent words in a column?
I have been tasked with creating metrics which show the current 'Top 5' most frequent countries in a column. I am struggling to create a formula which returns the correct value as new countries will be added to the list in future so COUNTIF would not work. So imagine the column read as follows: Germany France France…
-
How to use COUNTIF in a Sheet Summary Report
Hello - I am trying to add several COUNTIF formulas for different lines in my Sheet Summary Report. I would like the formula to reference how many times the status Action, Risk, etc. are in the column. I only get INVALID REF or UNPARSEABLE. I have tried the below among others, thank you! =COUNTIF({Log Entry Type},…
-
Using ISBLANK with a checkbox cell
I'm trying to create a formula for my sheet that is counting a total number of items in the sheet within certain parameters, I've gotten the formula down for most of them but where I've run into issues is that my final formula either needs to be based on a column that is a checkbox OR if another column is NOT blank. The…
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
Unique IDs for Testing Documentation
I may be overcomplicating this, but I wanted to see if you guys could help me. My team is building out some testing documentation for our projects. Our current set up is that we have a sheet that is basically divided into two halves. The first half is the general information for the test scenario. The second half is for…
-
Networking days taken from a start date and then one of two columns
I'm looking to find the average working days from the start date to the date of the job's first review. The first review could happen in two different ways represented in two different columns, a work in progress review, or an official review. Depending on the complexity of the job they may or may not need a WIP review. I…
-
Formula for counting bonus
Hi , Please find attached screenshot above .. i would like to create formula to input it in Cloumn [Bonus] to help us to calculate daily bonus for our employee sales as follow .. (1) if amount in Col [Daily Income] is higher than amount in Col [Target] to calculate the following Calculate 60% of the difference amount…
-
Formula to show total costs or TBD
Hi I am wondering if you can help me figure out a formula for my total cost coloumn. I need a formula that will total the section but if there is a "TBD" for a line item then instead of total numbers the top row just shows "TBD". So for this instead of show 19218.86 it would show TBD