This FAQ covers 3 common questions about entering the SHEET function, understanding results, and reviewing syntax, followed by a short glossary.
FAQ
What should I do if the SHEET function does not return the result I expected?
- Check whether the referenced argument points to the correct object.
- Confirm that the function name, parentheses, and separators are complete.
- Re-select the reference if needed, then press Enter again to apply the formula.
Why is my SHEET formula displayed as plain text instead of being calculated?
- Make sure the entry starts with an equal sign
=. - Check whether the current cell is formatted as text, then re-enter the formula if needed.
- Press Enter after editing so the formula can be calculated.
Where can I review the syntax and arguments for the SHEET function?
- Open the Formula tab and click
Insert Function. - Search for
SHEETand select it. - Review the syntax and argument details in the dialog box before continuing.
Glossary
| Term | Definition |
|---|---|
| SHEET | A built-in function in WPS Spreadsheet that returns the number of a referenced worksheet. |
| Insert Function | A function entry point in WPS Spreadsheet that helps you search for a function and fill in its arguments. |
| Formula bar | The input area above the worksheet where you can enter or edit formulas directly. |