-
Counts of values in a multi-select column
I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of contract types.
-
updating cells without loosing easy overview of historic data - how to?
We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay for 3 item Y, 0 item X and in March pay for 1 item X, 3 item Y. Q1: Is it possible to have the customer update this…
-
Vlookup Limitation?
Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.…
-
IF OR AND Statement
I am trying to return color symbols for in a sheet. End goal Date Null, Completed Null, or Past DATE(2020, 3, 31) = "Red" Date is Not "Yes" and Not Past DATE(2020, 3, 31) = "Yellow" Else = "Green" Here is the code =IF([Date Completed]1 > 0,IF(AND(NOT(Completed1 = "Yes"),[Date Completed]1 > DATE(2020, 3,…
-
Trouble with RGYB and blank dates
Hello! I am working with a Health column that refers to our Status column and start/end dates. I have a formula that is working once the dates are entered, but when I use a fresh templated sheet and there are no dates, it looks as if all the tasks are delayed. (see pic) I would like: Green if complete Yellow in in progress…
-
COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank
Hello, I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard). I need to count blank cells in a specific column, but only if another column has text. I'm using this formula: Where Range 1 will indicate if a new submission has been…
-
Formula for sum of values in columns of other sheets per collaborator. Cells assigned to "nn".
I have a summary sheet "Summary Sales" created from another sheet "ADMIN_2020" in rows 2, 3 and 4 of the "Summary Sales" I have 3 employees assigned. And I need to do the sum of the entire column (NETO column) from ADMIN_2020 for each independent contributor. Who can help me will be very grateful. regards
-
Formula to capture data in a cell on last day of the month.
I'm trying to figure out a formula that will capture the data ($) that is in a cell (on another sheet) on the last day of each month. Is this even possible? These are items that will move/change frequently so I just need to lock in the numbers at the end of each month and would prefer it to not have to be manual. Can…
-
How to save a formular if i export the table to an excel file?
Is there a way how to save or export a formular, so that i can reimport the (excel) file for an oncomming use?
-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…