Spreadsheets - DEV Community

Skip to content

DEV Community

👋 Sign in for the ability to sort posts by relevant, latest, or top.

SheetError

Nov 12

FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

#googlesheets #spreadsheets #productivity #tutorial

2 min read

Nov 10

I kept converting dates to MMWR epiweeks by hand. Then I stopped.

#publichealth #data #spreadsheets #epidemiology

2 min read

Serguey Shinder

Nov 10

Our Fuel Card Statement Went Through Excel and Three Drivers Were Accused of Buying Each Other's Diesel

#sergueyshinder #data #spreadsheets #fleet

2 min read

Richard C

Nov 9

Did that cancellation actually work? A cancellation check log in Google Sheets

#googlesheets #productivity #personalfinance #spreadsheets

5 min read

Nov 9

How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)

#excel #spreadsheets #realestate #tutorial

6 min read

SheetError

Nov 10

IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

#googlesheets #spreadsheets #productivity #tutorial

3 min read

Sebastian Bardach

Nov 12

Cost a restaurant menu in a spreadsheet: four formulas and one sheet layout

#spreadsheets #excel #googlesheets #tutorial

2 min read

Seller Sheets Lab

Nov 7

How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet

#spreadsheets #tutorial #bookkeeping #ecommerce

7 min read

SheetError

Nov 7

Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

#googlesheets #spreadsheets #productivity #tutorial

2 min read

Seller Sheets Lab

Nov 5

How to Build a Monthly Budget Spreadsheet with Formulas

#spreadsheets #tutorial #productivity #beginners

5 min read

InApp

Nov 4

Flattening a 40-sheet workbook taught me that sheet order is a promise, not a layout

#spreadsheets #markdown #api #ai

1 min read

Seller Sheets Lab

Nov 4

How to Track Your Etsy Search Rank in a Spreadsheet

#ecommerce #etsy #spreadsheets #productivity

6 min read

SheetError

Nov 4

#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero

#googlesheets #spreadsheets #productivity #tutorial

2 min read

SheetError

Nov 1

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

#googlesheets #spreadsheets #productivity #tutorial

2 min read

Oct 30

How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

#realestate #excel #spreadsheets #tutorial

6 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.