Category / Section
Common Error: Incorrect Input Range Format
1 min read
Issue Explanation
The input range format is incorrect. This error occurs when the selected range does not follow the required format(A1 Notation).
Correct Format
The correct format for the input range should include the following:
- Sheet Name: The name of the sheet.
- Beginning Cell: The starting cell of the range.
- End Cell: The ending cell of the range.
- Example:
Data!A1:B2
(in A1 notation format).
Solution
- Use the Update Button: Click the "click to update input range" button to automatically update the range based on your selection in the sheet.
Ensure your input range is in the correct format before proceeding.