Show Google Sheets Savings Progress on Your iPhone

To show savings progress from Google Sheets on your iPhone, give OneCell’s Goal Bar two values in the same row: the amount saved and the target. Select those two cells together and leave the designer’s Goal target field empty to use the target from your sheet.

This guide is for a number you already maintain in Sheets. It does not connect to a bank or update your savings balance for you. If this is your first OneCell widget, use the one-cell setup guide for Google connection, permissions and Home Screen placement. Widget creation requires active Pro access, including an eligible active trial.

Put saved and target amounts beside each other

Here is a fictional example. In a tab called Savings, enter:

• A1: Goal

• B1: Saved

• C1: Target

• A2: Book fund

• B2: 2500

• C2: 10000

Use the same unit for both amounts. Enter plain numeric values in B2 and C2, rather than text such as “25%” or “2/3.” The display needs the saved amount and the target themselves, not a precomputed percentage.

The expected progress is 2,500 divided by 10,000: 25%. The label in A2 helps identify the row, but it is outside the selected range.

Select B2:C2 for the Goal Bar

1. In OneCell, choose the spreadsheet and its Savings tab.

2. In the range picker, type B2:C2, then submit the entry or leave the field to apply it.

3. Confirm that SELECTED shows B2:C2, then tap Design widget.

4. Choose Goal Bar and set the label to Book fund. Include the unit in the label if it will otherwise be unclear.

5. Leave Goal target completely empty so the target comes from C2.

The first selected value is the current amount; the second column in that same row supplies the sheet target. Keep B2 and C2 side by side. A vertical selection such as B2:B3 does not supply the native widget’s target in the same way.

The Goal Bar shows whole-number amounts. For this example, expect 2,500 of 10,000 and 25% complete; number separators can vary by locale. A currency format applied in Sheets does not mean the widget will reproduce its currency symbol.

Choose which target should control the display

A value entered in the designer’s Goal target field overrides the target from C2. An empty field and a field containing zero are different settings: zero does not mean “use my sheet.”

If the widget should follow a target you maintain in Sheets, keep that field empty. If you deliberately want a fixed target instead, enter it there. For example, a saved amount of 2,500 with an explicit target of 5,000 represents 50%, even if C2 still contains 10,000.

When a percentage looks unexpected, check the selected range and that target field before changing the source amounts.

Save the design and check a changed value

Tap Add to home screen to save the configuration, then follow the placement instructions. Saving a design and placing it on the iPhone are separate steps. When the widget is placed, use Edit Widget to select the saved Book fund configuration. Apple’s add and edit widget instructions cover those system controls; wording can vary by iOS version.

With B2 at 2,500, C2 at 10,000 and Goal target empty, check for 25%. Then change B2 to 4000 while leaving C2 at 10,000. After a successful source refresh and widget update, the expected progress is 40%.

A sheet edit does not guarantee an immediate Home Screen change. iOS controls widget scheduling and refresh budgets, as Apple explains in Keeping a widget up to date. Check any displayed update time and the source value when freshness matters.

Check the inputs before reading the percentage

Use a nonnegative saved amount and a target greater than zero for this example. If nothing has been saved, enter an explicit 0 in B2. A blank cell is missing information; a displayed zero alone does not verify the balance in your sheet.

Correct blank, text, zero-target or negative inputs before relying on the progress display. Continue maintaining the saved amount and target in the sheet, and check the underlying values whenever the widget looks unexpected.