> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Google Sheets: Using Chips for Efficiency
- URL: https://www.jeffsu.org/productivity-ping-82/
- Published: 2023-03-31T01:00:04.000Z
- Updated: 2025-09-05T13:07:09.000Z
- Description: #82
- Author: Jeff
- Tags: #newsletter, Google Sheets

*(you can* [*filter previous editions*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

## Finance Chips

I used to rely on the “=GOOGLEFINANCE” formula to keep track of my investments within Google Sheets

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/image-55.png)

This formula gives you the stock price with a 15 minute delay

Now, you can just type in “@tickersymbol” to insert a Finance chip

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/image-56.png)

Hovering over the chip will give you the most updated price (including a default 15 minute delay)

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/image-57.png)

💡

****Pro tip:** Use ChatGPT to create a table with stock ticker symbols you can copy and paste directly into Google Sheets

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/CleanShot-2023-03-29-at-09.42.20@2x.png)

After you have the table, just copy and paste into Google Sheets

## Places Chips

I’m planning a trip to Hong Kong with a few friends and we can now easily insert specific restaurant locations using the Places Chips:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/image-58.png)

If you're in Hong Kong next week let me know ✌🏻

## Date Chips

This is probably the least useful since typing the date out (e.g. 4/1/23) really isn’t that much work.

But if you wanted to quickly insert yesterday’s, today’s, or tomorrow’s date, you can simply use the Smart Chips feature as well:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/03/image-59.png)

## ⌨️ Keyboard shortcut

- Get in the habit of always starting with “@” for Smart Chip options when using Google Workspace tools

[Follow up questions? Take me to the comments!](https://www.jeffsu.org/productivity-ping-82/#ghost-comments-root)

---

**I’m always looking for ways to improve** so give me anonymous feedback [here](https://forms.gle/4Dscq21VYF3fjCcn8?ref=jeffsu.org) 📝

**Want someone to be more productive?** Let them subscribe [here](https://www.jeffsu.org/#/portal/signup) 😉

Thanks for being a subscriber, and have a great day!