Formulas and Functions
Archives for July 2020
Discussion List
-
Yielding blank cellsIn Formulas and FunctionsHello, 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 y…Answered - Pending Review 11 views 2 comments 0 points Most recent by Esperanza Zagal Formulas and Functions
-
Help with a SUMIF formula and a reconciliation spreadsheetIn Formulas and FunctionsI 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 h…
-
Count IF for fixed datesIn Formulas and FunctionsI 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..…Answered - Pending Review 1 view 1 comment 0 points Most recent by Sean Morgan Formulas and Functions
-
#INVALID REF for WidgetIn Formulas and FunctionsHi 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 t…Answered - Pending Review 13 views 7 comments 0 points Most recent by Jamie Wisegerber Formulas and Functions
-
Counting Parents for a Specific YearIn Formulas and FunctionsOur 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 …
-
Get a distinct set of values from an existing column without changing order.In Formulas and FunctionsHello, 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…Answered - Pending Review 13 views 1 comment 0 points Most recent by SoS | Dan Palenchar Formulas and Functions
-
Multiple "OR" for single formula?In Formulas and FunctionsI 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: …
-
Symbols QuestionIn Formulas and FunctionsHello, 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 did…Answered - Pending Review 12 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
I was wondering what I would need to do to make this formula return the accurate number?In Formulas and FunctionsAt 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 s…Answered - Pending Review 15 views 3 comments 0 points Most recent by Deanna Vandermeer Formulas and Functions
-
Formula "Project is not complete and due day is passed"In Formulas and FunctionsHi 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. …