Articles in this section
Category / Section

Common Error: Index Out of Bounds in Details Task

2 mins read

Issue Explanation

An error occurred because the index specified in the details task is out of bounds: ${messages}. The maximum index is based on the input range.

Explanation of Absolute vs. Relative Index

Absolute Index

An absolute index specifies the exact location of a cell using its column and row labels. This format remains constant, regardless of changes or movements in the data range.

  • Format: [col A], [row 1]
  • Example: [col A] refers to column A, [row 1] refers to row 1.

Relative Index

A relative index specifies the location of a cell relative to the starting point of the selected input range. This format adjusts if the data range changes or moves.

  • Format: col1, row1
  • Example: col1 refers to the first column in the selected input range, row1 refers to the first row in the selected input range.

Solution

  • Edit Details Task: Ensure the index used in the details task is within the input range limits.
  • Valid Index Formats:
    • Relative Index: col1, row1
    • Absolute Index: [col A], [row 1]
  • Ensure Correct Indexing: Verify that your relative or absolute indexes do not exceed or fall outside the input range.

Sample Input Range vs. Valid and Invalid Index Format

Scenario 1

  • Input Range: Data!A1:B10
    • Valid Index: col1, row1, [col A], [row 1]
    • Invalid Index:
      • Absolute: [col C] (Column C is outside the range), [row 11] (Row 11 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row11 (Row 11 is outside the range)

Scenario 2

  • Input Range: Data!C5:D20
    • Valid Index: col1, row1, [col C], [row 5]
    • Invalid Index:
      • Absolute: [col E] (Column E is outside the range), [row 21] (Row 21 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row16 (Row 16 is outside the range)

Scenario 3

  • Input Range: Sheet1!E1:F15
    • Valid Index: col1, row1, [col E], [row 1]
    • Invalid Index:
      • Absolute: [col G] (Column G is outside the range), [row 16] (Row 16 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row16 (Row 16 is outside the range)

Scenario 4

  • Input Range: Sheet2!G10:H30
    • Valid Index: col1, row1, [col G], [row 10]
    • Invalid Index:
      • Absolute: [col I] (Column I is outside the range), [row 31] (Row 31 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row22 (Row 22 is outside the range)

Scenario 5

  • Input Range: Data!A1:C5
    • Valid Index: col1, row1, [col A], [row 1]
    • Invalid Index:
      • Absolute: [col D] (Column D is outside the range), [row 6] (Row 6 is outside the range)
      • Relative: col4 (Column 4 is outside the range), row6 (Row 6 is outside the range)

Ensure your relative index in detail tasks such as col1, row1 or absolute index such as [col A], [row 1] does not exceed or fall outside the input range. For further assistance, please contact our support team.

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Access denied
Access denied