-
COUNTIFS help
I have this formula but its's not counting correctly. I want to show a count of the Date Received column that have been delivered. =COUNTIFS({Gear Ship Schedule Template Platt Item}, AND(@cell <> "Qty", @cell <> ""), {Gear Ship Schedule Template Delivered}, <>"")
-
Date formula / duration question
Hi there, I have a Start Date column, an End Date Column, and a Duration (days) column. When the Start Date column is populated, I'd like for the Duration (days) column to count the number of days between start date until today. Only once the End Date column is populated, would I like for the Duration (days) column to lock…
-
Formula to create visual indication of a cell link in a row
Hi all, I would like to display a symbol in a column of a row IF a specific cell in that row is being used as a cell link to another sheet. I know that a small black triangle appears in the bottom right corner of the cell if it is linking to another sheet, but I would prefer a much larger visual indicator if that is…
-
Check Box if Name in another sheet matches name in current sheet.
I have a Purchasing Log that lists Vendor Name among other columns. I'd like to put together a formula where if the Vendor Name matches Vendor Name in another sheet and if so, return a checked box and if not return an unchecked box. I have messed around with MATCH, IF and INDEX functions and cant get anything to work. What…
-
Need Formula for RowID that will update when rows are deleted or added.
I need a column formula that will match the actual row ID even if you delete a row. I tried using autonumbering, but it does not update if you delete a row, or add a new row in the middle of your old rows. Ex. of AutoNumber row issue 1 (Row 2 deleted below, 3 should change to 2) 3 5 (New Row added, should change this row…
-
Filter tables based on dropdown menu selection
Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustrate what I'm looking for. Here's what the raw tables look like. They are laid out like…
-
Creating row formula to be repeated on the same sheet
Good day, can anyone guide me in creating row formulla?. I have a set of data, the normal lies within certain range. When it is above the range, I want it to reflect 'red' bubble, when within the range 'green' bubble and when below, 'yellow' bubble (attached). The issue is that I want this row formula to be repeated on the…
-
Problem with returning a value when a cell is blank
Hello - The first half of the formula below seems to work fine. However i need to return a value if ([Opportunity End Date]@row) is not blank. I'm either receiving #unparsable or #incorrect argument. If you could help, would be greatly appreciated. =IF(ISBLANK([Opportunity End Date]@row), TODAY() - ([Opportunity Creation…
-
Need Help with Invalid Operation
I'm getting Invalid Operation with this formula since the division equation is dividing by zero. How do I fix this so that it shows like "0 of 0 (0%)". If this isn't possible then I'd like to have "Not Yet Started" as the text entered. =COUNTIF(CHILDREN(), >0) + " of " + [Clock In Location]@row + " (" +…
-
IFERROR(INDEX(COLLECT.... Contains
I am trying to use the below formula to collect LOB based on the Functional unit and Managing office provided. I am referencing another sheet which contains a matrix of Functional Units and Managing offices that fall under certain LOB =IFERROR(INDEX(COLLECT({LOB}, {FU}, CONTAINS([Functional Unit (Dept ID)]@row, @cell,…