Ask Your Question
3

What is the issue when Google Sheets cannot locate a script function?

asked 2022-12-09 11:00:00 +0000

bukephalos gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2022-03-31 11:00:00 +0000

qstack gravatar image

The issue is likely due to one of the following reasons:

  1. Typographical error: There may be a typographical error in the function name or parameter names.

  2. Incorrect function library: The function may not be part of the library that is currently being used. Double-check the library being used and ensure that the function is in that library.

  3. Permissions: The user may not have the necessary permissions to use the function. Check the script editor to make sure the user has been given editing permissions.

  4. Broken script: The script containing the function may have errors. Review the script for any syntax errors or try rerunning the script.

  5. Case sensitivity: The function name may be case sensitive. Double-check the case of the function name to ensure it matches the case in the script.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-12-09 11:00:00 +0000

Seen: 8 times

Last updated: Mar 31 '22