Formulas
Discussion List
- Hi all, I created the following formula to search through another sheet and, if a location has submitted a row in the applicable month, it is supposed to check the box on our confirmation sheet. It wo…
- I'm having some difficulty in associating a date cell created by a blueprint program with the project it creates. Is there a way to change this that I'm unaware of? Setup Summary: I have a blueprint t…
- I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am …
- Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) fun…
- I am using an INDEX/COLLECT Formula: =INDEX(COLLECT({IP}, {Site}, SIte@row, {Lane Number and Direction}, [Lane Number/Direction]@row), 1) This works great. Except for when the Lane Number/Direction is…
- Hi all! I am trying to collect an average over the last 12 rows (including the current row). To do this, I created 2 additional helper columns (Line-ID and Row#), and trying enclosing the condition in…
- Hello, I'm struggling with a formula that is returning an in valid column value error. All columns are Text/Number. Sheet 1 has one row for each project. Sheet 2 has a column that may have multiple pr…
- I need to add an IF statement into an INDEX MATCH formula that pulls the system size of a column if it is not blank. This formula will be on sheet #1 and needs to be an IF, INDEX, MATCH. Sheet #2 will…
- I need to be able to create a formula that will return the highest value based: I want it to match the Auction Item and return the highest value in the Bid column and the name of the highest bidder In…
- Hi, I am trying to use this formula =IF([Next inspection due]@row <= TODAY(0), 1, 0) then mark it with a flag. in the Flag Due Date column. Every time I use this formula I get INVALID OPERATION becaus…