Community Discussions

google sheets as a database

I would recommend google sheets as a database save html forms directly to google sheets

Top Answers
Value scoreboard with if statements with choices

Hello, I have tried googling a bit but did not find any answer that really made me understand how to do it :) I want to use a scoreboard with different values across multiple tabs (worksheets) th...

Top Answers
What software would you recommend to track commission and manage referrals?

My business has ended up receiving a lot of income from referrals to other businesses in our industry. The companies we're receiving referrals from are all run very differently and have complicated...

Top Answers
How can I calculate percentage differences between multiple percentage values in google sheets?

I need help to know how I can do this the best/correct way :) So my case is: I have a spreadsheet my collegues filled in with different prices from different locations and my task is to count the ...

How can I edit the formatting on Google Forms results?

Our counseling team uses a Google form for our student requests. We have the requests with the most recent on top, and we would like to be able to highlight or change the font color of the student...

How do you find duplicate rows and merge with combined values using Google Form and Sheets?

I am using Google Forms and one user entered the same job number multiple times. I want to combine the cells associated with those job numbers into a final value/summary. Does anyone have a recomme...

How should I get Google Sheets to help manage an interactive inventory sheet?

I've tried using pivot tables from a master data list we update: We have over 50 beer taps in 3 different locations. I originally used other pivot tables to pull data to an area I wanted the upda...

Google Sheets? Airtable? MySQL?

Guys... In "digital marketing world" it's very common to use Google Sheets to store data. Ex: → Metrics from Facebook Ads → Google Sheets → Google Data Studio → Metrics from Google Ads → Google ...

Pro-Tip Search: How do you deal with CSVs?

I deal with a lot of CSVs. I export them from analytics software, from email/CRMs, etc. I almost never want them in Excel, I want them in Google Sheets or even just to copy/paste the values out of ...

What software do you keep connected with integrations?

Some software can stand alone, no other tools needed. You could use Photoshop or PowerPoint on their own forever without missing out on much. Other tools thrive with connections. You could use a f...

What’s your favorite app to make presentations and slide decks?

After decades of PowerPoint being so popular that “PowerPoint presentation” is almost a generic term, presentations are suddenly a hot space. Apple’s Keynote has long been a more design-focused alt...

Do you use kanban in your CRM, or do you have another way to organize leads and contacts?

Pipedrive perhaps most famously made a kanban-style workflow the default way to move leads through a sales process, and similar kanban workflows are now common in many CRM apps (along with project ...

Google Apps, then G Suite, now Google Workspace: Google rebranded their office suite again.

The Google team decided it's time for a new rebranding of their office suite, so the paid, professional set of apps including Google Docs, Google Sheets, Gmail, and more is now called Google Worksp...

Top Answers
How do you automate follow-up emails?

I've got a funny use-case for a client I'm volunteering on. They're dealing with some legacy folks who work in Excel. Every week they send out an email to a series of people with an Excel sheet at...

Built-in automations vs. dedicated automation workflow software?

Tools like Zapier, IFTTT, Integromat, and more make it easy to connect data between apps and get work done automatically. But sometimes they're not needed. It's increasingly common for software to...

You can find how many Twitter followers anyone has from Google Sheets.

https://twitter.com/chasmaxson/status/1298367284553977856

Top Answers
SaaS Landing Page Feedback from the Best?

Hi Everyone, As follow B2B SaaS buyers, I know y'all have the best eye for landing pages. After buying and implementing software at large companies for a few years, I finally started building my o...

How to experiment with word choices in Coda for UX writing and more.

Ever wanted to see how different words would sound in your copy, without having to entirely rewrite your copy? Coda lets you include spreadsheet variables directly in your copy—which means you b...

What software should a modern office suite include?

For over 30 years, the Office suite has meant a bundle of software including a word processor, spreadsheet, and presentation tool among other apps. But are those the most relevant tools for a mode...

Office Suite: LibreOffice, GSuite, Microsoft Office

We use a combination of MS Office and GSuite, but I'm a bit over the recurring cost of MS Office when we don't use it all the time. It's something we have in case we get an excel file. Has anyone ...

Excel vs. Google Sheets: What's the best spreadsheet in 2020?

It's been decades since spreadsheets became the original killer app on personal computers, one of the main reasons people bought early PCs and Apple IIs. And they're still some of the most versatil...

What is your favorite kanban board layout?

Kanban boards are everywhere, after Trello popularized them with its simple kanban-only workflow. You can reorder your Asana tasks (along with those in many other project management apps) in a kanb...

What personal finance platform do you use?

Currently I keep track of personal finance using a simple Google Sheet but thinking of trying out a tool like Mint or Monarch (when they open for more invites). Any recommendations?

What software do you wish existed?

What software are you looking for that you've never been able to find, and wish there was something for that exact use case? Maybe there's something that almost fits your needs but not quite. Or m...

What are your favorite tools to build an MVP?

I've used Airtable extensively to build simple internal apps as minimal viable products, but would love to build something bigger without coding. What are your favorite tools to build MVPs?

Have a question about Google Sheets?

Ask here.