Formulas

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…

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…

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…

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

Does anyone know of a way to find and replace formulas in my sheet? Or to find and replace a portion of a formula that exists throughout my sheet? 

Hello, I'm hoping for some help or prior experience with a layered formula I am trying to create. I would like to pull all of the names assigned to tasks into a sheet summary field where the value is not blank. Ideally the formula would only pull unique values. I was trying to work with combinations of the INDEX, COLLECT,…

This discussion has been merged.

Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market delivered in a specific month. so all type A, from Jazz AT, in April. Thanks in advance Katie

I am trying to count values from a column that is a dropdown/allow multiples column. For example, there are three dropdown options to choose from - red, green, blue. Cells will have one or more dropdown items selected. I need to count all cells that have red selected (regardless of the other choices). THat is, the number…

Hi, I have the below formula which is working correctly: =IF([Item Name]@row <> "", IF(ISBLANK([Actual Sign Off Date]@row), "TBC", IF(AND([Actual Sign Off Date]@row <= [Sign Off Required Date]@row), "ON TRACK", IF(AND([Actual Sign Off Date]@row > [Sign Off Required Date]@row), "DELAYED")))) I have another formula which is…