-
count tasks "on fly" per work week.
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its finished. task start 10.08.20 finish 20.08.20. ww31 ww32 ww 33 ww34 1 task 2 tasks 2 tasks 1 task
-
IF OR IF Returning two different values based on cell input
I have one cell that can have multiple values. I need a formula to return one value if one set of criteria are met, another value if only one of those values is different. I know it's a syntax issue that I'm not quite understanding correctly. I have the following formula working: =IF(AND(Priority@row = "1 Urgent", [Update…
-
Stumped on formula
I need a formula that I'm not sure I can do. I have tried many different things, and only have a portion working. I need to be able to determine the "difference" between our $$ bid and either the low bidder, if we are not, or the 2nd bidder if we are the low bid. I've tried several If, or versions but getting nowhere…
-
counting multiple instances of one keyword in one cell
I'm trying to count the number of instances of a keyword in one cell (for instance if I have "Green Apples; Yellow Bananas; Brown Bananas; Reg Apples" in my Products column for this row, I want to count the number of times "Apples" appears in the Products cell for this row, which should be 2). I'm using this formula:…
-
Row Copy Workflow not working
I created a work flow to copy a row to another sheet. At first i use criteria when the reference number changes to any value, copy to another sheet. that worked. But when i added additional criteria of "AND when the Date of Final Approval is not blank" the rows are no longer copied. I tried changing destination sheet to…
-
CountIFs
Hi I am trying to do a count if to see the following if the value selected is Milestone and the status selected is Complete at the moment I have tried this =COUNTIFS(Value:Value, "Milestone", Status:Status, "Complete") but its returns an unparsable or circular ref and the also blocks the formula I have to see the total…
-
WEEKLY COUNT
Hello, I need to create a report showing weekly "BOOKED" per category and associate. Weekly is from M-F. My sheet looks like this below: Thank you so much.
-
SUMIF formula that calculates the criteria between a number range
Having a blank mental moment. I am trying to create a sum if formula to total all of the "medium" priorities using a range of numbers. High is fine as i just did a greater or equal to (>=) and likewise (<=) for the low. When I get to the medium priority, I can't work out how to do an "in between". Below is a screen shot of…
-
Formula to Change RYG Status Ball if One or Another Cell Values is Set
Hello, I'm trying to figure out the right formula to change the RYG status ball depending on the status set in two different cells. I've tried various IF and OR combinations referenced in community threads but am missing something. Here's my column info: Column 1: Engagement Column Status to trigger Red status ball: Left…
-
How to track late information
Hi, I'm looking to track information that has been received late on some sheets. See below example where date information required was 17th July and we received the info on the 26th July. I am using =IF([Date Information Received]@row > [Date information Required]@row, "Yellow") to turn a symbol yellow if date information…