Google Sheets 1RM Calculator
Supercharge your Google Sheets workout tracker with automated ArrayFormulas, Sparkline charts, and Apps Script functions.
Choose Sheets Workflow
=ARRAYFORMULA(IF(ISBLANK(B2:B), "", IF(C2:C=1, B2:B, ROUND(B2:B*(1+C2:C/30), 1))))Use our pre-configured Google Sheet with built-in 1RM dashboard, volume heatmaps, and 5/3/1 cycle tracking.
🚀 Make a Copy in Google DriveWhy Google Sheets is the Ultimate Lifting Log
Google Sheets combines real-time smartphone gym entry with cloud charting, letting you log a set on your phone and instantly view your projected 1RM curve.
Custom Apps Script Function
Paste this snippet into Extensions > Apps Script to create your own native sheet function:
/**
* Calculates One Rep Max using the Epley Equation.
* @param {number} weight Weight lifted.
* @param {number} reps Repetitions completed.
* @return Estimated 1RM.
* @customfunction
*/
function ONE_REP_MAX(weight, reps) {
if (!weight || !reps) return "";
if (reps === 1) return weight;
return Math.round(weight * (1 + reps / 30) * 10) / 10;
}Frequently Asked Questions
Everything you need to know about Google Sheets 1RM setups.
ARRAYFORMULA resides in a single top cell (D2) and evaluates new workout rows automatically as you log them on your phone, keeping your spreadsheet clean and free of formula-drag errors.
Yes! The Google Sheets mobile app syncs across devices instantaneously, allowing you to log weights on the gym floor while viewing analytics on your desktop at home.