Circular Dependency in Array Formula Shared
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGH
1
Task NamePreceding Task NameExpected Values with simple formulasExpected Values with Array formulaYogi Array FormulaComments
2
First Default Task1???1
3
Concrete foundationFirst Default Task22
4
Wood framingConcrete foundation33Hi Raiwiz: what is the logic behind reading the value in column A and adding 1 to value in column D?
5
Wall OSB sheathingWood framing44The logic is that you find the previous task in col A and then take its sequence from Col D. Then I add one to say that this task is happening later than the prevous task. So at the end this task has larger sequence number
6
Floor OSB sheathingWood framing44In other words: Col D is a task sequence. At first we need to find out the sequence number of previous task (defined in Col B) and then add number 1
7
Door inst.Wall OSB sheathing55Does that help?
8
Floor inst.Floor OSB sheathing56← Not Correct, cuz 'Floor OSB sheathing' is at A6. Take value at D6 and add number 1
9
Door casing inst.Floor inst.67← Not Correct, cuz 'Floor inst.' is at A8. Take value at D8 and add number 1
10
Door paintingDoor casing inst.78← Not Correct, cuz 'Door casing inst.' is at A9. Take value at D9 and add number 1
11
Handle inst.Door painting89← Not Correct, cuz 'Door painting' is at A10. Take value at D10 and add number 1
12
Lockset inst.Door painting89← Not Correct, cuz 'Door painting' is at A10. Take value at D10 and add number 1
13
Window inst.Wall OSB sheathing55
14
Window sill inst.Window inst.610← Not Correct, cuz 'Window inst.' is at A13. Take value at D13 and add number 1
Loading...
 
 
 
Sheet3
JP
Copy of JP
Sheet1
Sheet2
Testing JP