-
IF & ISBlank Function
I am trying to test whether or not the score inputted is greater than 80 or less than 80. If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed". If the score is less than 80 I would like my status column to populate with a string labeled "Failed". Heres the issue, I am…
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
Cross sheet Formula to pull in column value
Hello, I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull…
-
Index, Match with Find and Left function
I am trying to get a formula to look up a value with the INDEX / MATCH function and the Search_Value being the numbers up to a "-" dash from the "Type For List" column. The index/match does not seem to like the LEFT or FIND functions Has anyone come across this or has a work around? =INDEX({O_Type}, MATCH((LEFT([Type For…
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
IF statement with child/parent logic
The Problem: I need to have autonumber as a Unique Identifier for each row. When that row changes due to changing business requirements, I want to create a child row but it should not have a different Unique ID from the parent. It could either have the same Unique ID or no Unique ID, but if I have autonumber turned on then…
-
Row number calculations as part of a formula
Hi there, I'm trying to replace the value of a row number in a formula. I have created a rowID column so each row has a row number in that column. I would like to make calculations from that to replace the row number part of a cell reference with calculated value i.e. =Status123 i want to be =Status(row#+Y) How do I…
-
How to avoid #REF errors when referenced cell is deleted
I am trying to make a Sheet Summary field that always references the first row in the column (aka ColumnName1). But if I make that reference and then the row is deleted, the reference breaks and gives a #REF error. How can I make a formula that will always reference the first row in the column regardless of what happens in…
-
HELP with IF formula and cell reference
I would like to check cell [Actual Finish Date}4 for a date before executing =IF(ISBLANK([Planned Finish Date]4), 0, IF([Planned Finish Date]4 < TODAY(), 1, 0)) which sets a FLAG to true. If [Actual Finish Date}4 has a date then set FLAG to false. If there is no date then execute on the above formula.
-
Master Sheet - Exceeds Row Limit
I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master customer listing of 6200 customers. I use DataUploader to upload this into 3 sheets due to size…