DEV Community

#spreadsheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Did that cancellation actually work? A cancellation check log in Google Sheets

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

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

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

Comments
6 min read
How to Build a Debt Payoff Planner in a Spreadsheet

How to Build a Debt Payoff Planner in a Spreadsheet

Comments
7 min read
How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet

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

Comments
7 min read
Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

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

Comments
2 min read
How I Plan a Whole Week in 15 Minutes (the Sunday Template That Actually Survives Monday)

How I Plan a Whole Week in 15 Minutes (the Sunday Template That Actually Survives Monday)

Comments
4 min read
How to Build a Monthly Budget Spreadsheet with Formulas

How to Build a Monthly Budget Spreadsheet with Formulas

Comments 1
5 min read
Flattening a 40-sheet workbook taught me that sheet order is a promise, not a layout

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

1
Comments
1 min read
How to Track Your Etsy Search Rank in a Spreadsheet

How to Track Your Etsy Search Rank in a Spreadsheet

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

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

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

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

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

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

Comments
6 min read
How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

Comments
7 min read
VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Comments
2 min read
How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.