Google Sheets无代码实现参数化矩阵公式及反馈查询问题

Great news—you don’t need to write any code to build this parameterized function! Google Sheets has built-in support for custom named functions that let you turn your formula into a reusable, parameterized tool. Here’s how to set it up step by step:

• Open your Google Sheet, then go to Data > Named functions in the top menu bar.
• Click the Add new function button to start building your custom function.
• In the "Function name" field, type MATRIX (this is what you’ll use to call the function later).
• Add a short description (e.g., "Generates a matrix with specified rows, columns, and fill value") to make it clear what the function does.
• Next, define your three arguments:
  • Click Add argument, name it rows, and add a description like "Number of rows in the matrix".
  • Repeat for cols (description: "Number of columns in the matrix") and valued (description: "Value to fill every cell in the matrix").
• In the "Formula definition" box, paste this formula (note: we remove the @ symbols here since we’re using the argument names directly):

  MMULT(TRANSPOSE(SPLIT(REPT(valued & "|", rows), "|")), SPLIT(REPT("1|", cols), "|"))
  

• Click Next, then Create to save your function.

Now you can use it just like any built-in Google Sheets function! For example, =MATRIX(10,5,5) will generate your desired 10x5 matrix filled with 5s. A quick edge case note: this works for both numbers and text—just pass text as the third argument (e.g., =MATRIX(3,2,"Test")).

When you submit a problem via Help > Report problem in Google Sheets, there are two reliable ways to track its status:

• Directly in Google Sheets: Go back to Help > Report problem. At the bottom of the dialog that opens, you’ll see a "View your reports" option. Clicking this will show you all reports you’ve submitted, along with their current status (like "Received", "Under review", or "Resolved").
• Check your linked email: The Google Sheets team sends status updates to the email address tied to your Google account. Be sure to check your main inbox, as well as spam or junk folders, in case the message got filtered there.

Keep in mind that response times vary based on issue complexity. For feature requests, you might not get a direct reply, but your feedback is logged and considered for future updates.

内容的提问来源于stack exchange，提问作者Riyaz Mansoor