-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…
-
Help with a SUMIF formula and a reconciliation spreadsheet
I am trying to build a reconciliation spreadsheet that compares two sets of data. Pictured below: The first set of data with the "QBO SKU" is pulling the information correctly using the below formula: =SUMIFS({QBO – shipment history (7/30/20) Range 1}, {QBO – shipment history (7/30/20) Range 2}, Class@row, {QBO – shipment…
-
Count IF for fixed dates
I am trying to do a simple CountIF, where the 'if' is whether an Expiration Date field is between a certain range, for example for if Expiration Date in in = January 2020, I would want to count any expiries between 1/1/2020 and 1/31/2020...it doesn't have to be relative, the expiration dates are 'fixed' in the sheet so…
-
#INVALID REF for Widget
Hi Community. I'm hoping someone can help me out. I created a task tracking sheet. A general rule is that our reporting month is always two month behind today. In my sheet summary I have a formula using index match, which works perfectly to my expected results. I am using a date reference table so I can see the month name…
-
Counting Parents for a Specific Year
Our organization receives requests for work and some of these requests may have multiple actions that need to be completed. I have the additional action(s) indented under the first action (request) to try and display that this one request had multiple actions. Is there a way that I can count the level one action (request)…
-
Get a distinct set of values from an existing column without changing order.
Hello, I am trying to get list of values that has each value only once. Below I have my JOB NUMBER column and I am trying to create an automatically updating column that we will call DISTINCT NUMBER that lists each number once. The catch is that the JOB NUMBER column is always changing and I want the DISTINCT NUMBER column…
-
Multiple "OR" for single formula?
I have about 14 single choice options in a column that if chosen, lead to a specific Harvey ball status. I've used multiple "Or" entries, and I wonder what I'm leaving out, as it's coming back unparceable. Here's the formula: =IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting…
-
Symbols Question
Hello, I'm receiving an "Unparseable" error on the below. I have a column where I selected symbols to display different statuses. I selected the colored circles where it is Green, Yellow, Red and Grey. Is this issue because I didn't apply the Yellow? =IF(Status@row = “Blocked”, "Red", IF(Status@row = “Closed”, “Grey”,…
-
I was wondering what I would need to do to make this formula return the accurate number?
At the moment, I have a formula that is not actually doing what I need it to do. Basically what I have is an inventory sheet and when folks remove from the inventory I need it to look at the cost of that item from the cost column in that specific row and return a total $ Amt Used. However, occasionally, the item is…
-
Formula "Project is not complete and due day is passed"
Hi everybody, could you help me with a formula please: The Idea is if the Status of the project is not "Complete" and due day is passed (it's more then TODAY), i need the red symbol in the column. In other cases, i need nothing. Here is my formula looks like: =IF(Status22 = "In Progress", "", IF(Status22 = "Not Started",…