-
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
-
Find and replace formulas?
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?
-
Formula to collect nonblank values in assigned to column for sheet summary
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,…
-
Formula help
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
-
Help with Countif / Countifs formula
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…
-
IF and TODAY
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…
-
Trying to count total dates in a column for a specific date range
I'm trying to count the number of submissions of a specific activity in a specific time period. For example, I want to count the number of submissions for Task A in (Task A/B column) that were submitted in the period >=3/6/23 to <3/14/23 in (Submission Date Column). I have filtered the file manually and the correct number…
-
Return Date that falls within 10 days of another date
So essentailly we have 2 sheets. On 1 sheet we have a list of test dates(call it test dates). Then on the main sheet we a column for due dates for certain documents where if not turned in Student would be locked out and can not take tests. So we want to have another column on the main sheet that pulls dates from the test…
-
How can I work around the Formula Cell Reference Limit?
Hi, I'm getting the below error message. My needs are too complicated to convert any of the formulas to automations and I'm not sure how to simplify. Here is essentially what I am trying to do - every row is a different item and columns A, B, C, and D contain fabric codes. In columns A1 and A2 (and B1, B2, C1, etc.) I need…
