Everyday goals
Show Two Google Sheets Figures Together on Your iPhone
Published by OneCell
To show two Google Sheets figures together on your iPhone, put each label beside its value and select the two data rows for OneCell’s Key/Value widget. For the example below, select A2:B3 and use Medium size: one row for orders and one for returns.
This is for values you already maintain in Sheets. Displaying them together does not calculate a total, connect to an order system or decide what the numbers mean. Keep their definitions and reporting period clear in the source.
Start with two labeled data rows
Here is a fictional example in a tab called Dashboard. The headers identify the columns, but will stay outside the widget selection.
A1: Metric
B1: Value
A2: Orders today
B2: 12
A3: Returns today
B3: 0
Check the two pairs in Sheets before selecting them. B2 belongs to the orders label in A2; B3 belongs to the returns label in A3. For this example, expect two rows: ORDERS TODAY with 12, and RETURNS TODAY with 0.
If your figures are already arranged this way, use those data rows rather than creating another dashboard. Choose short labels that identify the number and period without needing the rest of the sheet.
Select A2:B3 and choose Key/Value
Creating a widget requires active OneCell Pro access, including an eligible active trial. The one-cell iPhone setup guide covers connecting your Google account, permissions and native Home Screen placement. Use the Google connection for a restricted private sheet; selecting a range controls the display, not the breadth of Google authorization.
Choose the spreadsheet and its Dashboard tab in OneCell.
In the range picker, type
A2:B3, then submit the entry or leave the field to apply it.Confirm that SELECTED shows A2:B3, then tap Design widget.
Choose Key/Value and Medium size. The first selected column supplies the labels; the second supplies their values.
Check both pairs in the preview. Use a recognizable configuration label such as Today’s counts.
Tap Add to home screen to save the configuration and follow the placement instructions. On the placed iPhone widget, use Edit Widget to choose this saved configuration.
Saving a design and placing it on the Home Screen are separate steps. If another saved widget already exists, explicitly check which configuration the placed widget is using.
Change the second value without changing the first
Keep B2 at 12 and change B3 from 0 to 2. After a successful data refresh and widget update, expect orders to remain 12 and returns to become 2. That gives you a specific pair to check if the wrong row or saved configuration appears.
An actual zero and a missing value are different. With 0 in B3, the second pair shows zero. A blank or missing second value shows an em dash, —, rather than a verified zero. Fix a missing input in Sheets before relying on the display; enter zero only when it accurately describes the value you maintain.
A sheet edit does not guarantee an immediate Home Screen update. Apple describes system scheduling and refresh budgets in Keeping a widget up to date. When freshness matters, check the source and any displayed refresh time.
Check headers, formatting and the period
Key/Value does not automatically skip a header. If you select A1:B2, the first pair becomes METRIC with Value and the second becomes ORDERS TODAY with 12. Returns is outside that selection. Medium shows two rows, so including a header uses a row that could have held a figure.
Keep the selection to the two label-and-value columns. Adding a third column does not add another value to each pair. If a label or value is too long to read comfortably, shorten the source label or choose a more suitable display before relying on it.
OneCell reads the formatted Sheets values. Apply any needed number or currency format in the source cells; Google’s value-rendering documentation explains how calculated results use cell formatting and the spreadsheet’s locale.
Finally, check what “today” means in your sheet. These sample cells do not reset themselves or select transactions by date. Continue updating the values through your existing process, and change the widget’s source selection if the relevant rows move.