When using Level, the most common questions fall into 3 areas: star range, formula use, and data sync; this FAQ covers 3 common questions.
FAQ
How many stars does the Level field support?
- The Level field supports 1 to 5 stars by default.
- If you need a different total number of levels, adjust the field settings on desktop.
- After adjustment, you can use the field for different rating scenarios.
Can the Level field be used in formulas?
- Yes. Each star level maps to a numeric value from 1 to 5.
- You can reference the field in formulas for totals, averages, and similar calculations.
- After you enter stars, the stored value participates in calculations as numeric data.
How to sync star ratings entered on iPhone to other devices?
- Make sure you are signed in with the same WPS account.
- Check that the device network connection is working normally.
- Reopen the data table or check again later on another device.
Glossary
| Term | Definition |
|---|---|
| Level field | A data-table field that shows and records ratings with stars. |
| Star rating | A way to enter a score with 1 to 5 stars. |
| Formula reference | Using the numeric value behind the Level field in a formula. |