Only Expert Can Give Simple Explanation How This time management metric is working.

[asolopreneur]

The "Prioritized To-do list" is arranging the To-do list items as they are segmented in the first workbook to-do list. It's perfectly working but I want to know how the formula is working? How can I breakdown this complex formula?

=ArrayFormula(IF(ROWS(D$4:D4)>$D$2,"",INDEX('Brian''s To-Do List'!$A$1:$A$55,SMALL(IF('Brian''s To-Do List'!$B$2:$B$55=3,ROW('Brian''s To-Do List'!$B$2:$B$55)),ROWS($D$4:D4)))))

https://docs.google.com/spreadsheet...dwxccwGwD09rxSeDVbx1uL2j8/edit#gid=2145792177

 

[Jeffrey Mahoney]

The first part is easy "ROWS" returns the number of rows in the range. If the number of rows is greater than the value in D2, return a blank. D2 is a formula to count the number of items that match the quadrant (3).
IF(ROWS(D$4:D4)>$D$2

INDEX(array, row_num) - Return the value from the range provided at row number given. Range is A1:A55 on the To-Do list sheet. In this case the IF is used to test if the Quadrant is 3 in column B (IF('Brian''s To-Do List'!$B$2:$B$55=3). Then SMALL is used to return the next value in line. SMALL(array, k) where array is provided from the IF statement and k = ROWS($D$4:D4) which is the count.

In Excel you would finish the Array formula by pressing Ctrl-Shift-Enter. In Google Sheets it seems they have a function that servers that purpose.

Jeff