Everyday goals

Show a Small Google Sheets Table on Your iPhone

Published by OneCell

To show a small Google Sheets table on your iPhone, select its header and a few short data rows in OneCell, then choose Table. Keep the fields that belong together: an item, its shelf and its count, for example. The Table widget displays up to five selected rows and four columns, with the first row counted in that limit.

This is a view of values you already maintain in Sheets. It does not count stock, record movements or replace the source when you need the full table.

Choose the rectangle you actually need to check

Consider this fictional example in a tab called Stock check. Each line below describes one spreadsheet row:

  • Row 1: A1 = Item; B1 = Shelf; C1 = Count

  • Row 2: A2 = Clips; B2 = A; C2 = 12

  • Row 3: A3 = Pads; B3 = B; C3 = 0

  • Row 4: A4 = Labels; B4 = C; C4 = 8

The selection is A1:C4: three columns and four total rows. Its last row should read Labels | C | 8. Keeping Shelf beside Count lets you tell which location the number describes.

For your own table, choose the existing rows that answer your question. Do not select a whole inventory merely because it is available. If the useful rows are far apart or the short view leaves out essential context, opening the source may be more useful than this widget.

Select A1:C4 and use Table

Creating a widget requires active OneCell Pro access, including an eligible active trial. Use the iPhone setup guide for connecting your account and placing the saved widget. For a restricted sheet, use the Google connection; selecting a display range does not narrow Google authorization to those cells.

  1. Choose the spreadsheet and its Stock check tab in OneCell.

  2. Type A1:C4 in the range field, then submit it or leave the field to apply the selection.

  3. Confirm that SELECTED shows A1:C4, then tap Design widget.

  4. Choose Table and try Large size. Check all three columns and all four rows in the preview.

  5. Use a recognizable label, such as Shelf counts, then tap Add to home screen to save the configuration and follow the placement instructions.

  6. On the placed iPhone widget, open Edit Widget and choose the saved Shelf counts configuration. Check its size and readability again.

A larger widget does not increase the Table’s five-row, four-column limit. Shorten long source labels or select fewer fields if you cannot read them comfortably. The first selected row is styled as a header; OneCell does not detect which row in your sheet was intended as one.

Check a changed cell and an empty one

Leave the other sample cells unchanged and change C4 from 8 to 6. After a successful data refresh and widget update, the Labels row should read Labels | C | 6. Clips should still show 12 and Pads should still show 0. If a different row changes, check the selected tab, range and saved configuration before relying on it.

Now consider C3. An actual 0 means the source contains zero. Clearing C3 leaves that table cell blank; it does not establish that no pads remain. Check missing information in the source rather than treating an empty display as a verified count.

Sheet edits do not guarantee an immediate Home Screen change. Apple explains variable scheduling and refresh budgets in Keeping a widget up to date. When the current count matters, check the source and any displayed refresh time.

Keep the header and limits in the check

Row 5 is outside the A1:C4 selection. If you extend to A1:C6, Table can display only the first five selected rows: the header plus four data rows. Row 6 is beyond the display limit. A fifth selected column is also beyond the four-column limit. Blank rows still take a row slot, so do not count them as spare capacity.

OneCell reads formatted Sheets values, as described in Google’s value-rendering documentation. Set number formats in the source, but do not depend on source cell colors or conditional formatting appearing in the widget. Keep any meaning you need in readable labels and values.

Continue maintaining the counts through your existing process. If the relevant items move to different rows, check the range again: this selection follows cell coordinates, not a promise to find those item names elsewhere in the sheet.