Type the formula
A formula bar, range highlights, and column-name autocomplete. Placement also has a few multiple-choice checks.
Formula practice for people who switch tools
Learn a formula once. Use it in every spreadsheet.
Type real formulas against workplace data. Toggle Excel syntax, Smartsheet syntax, and Google Sheets. The grader checks the sheet you can see, then three sheets you can’t, and tells you why a near-miss failed.
On this browser
Continue where you left off
Point at a cell
No practice streak yet. It starts when a check passes. It is stored in this browser and is not sent anywhere.
=JOIN(COLLECT([Task]:[Task], [Status]:[Status], "Done"), ", ")
JOIN puts the range first and the delimiter second. TEXTJOIN puts the delimiter first. This practice engine drops blank cells inside JOIN. That blank behavior was not checked in a Smartsheet sheet.
Hidden sheets
A formula that only works on the sample fails the next dataset, with the expected value beside yours.
The other syntax
After you solve it, see the same idea in the other two products — including where no equivalent exists.
Start from the level, or from the job
Beginner modules are the new starting point. The cards below are the role paths.
Project manager
Totals, status flags, working days, and a small hierarchy.
StartOps and analyst
Criteria, lookups, and the list functions that replace a pivot.
StartSheet admin
The functions that only show up once a sheet has hierarchy, multi-selects, or another sheet.
StartMoving between products
The same idea, written in the syntax the other product expects.
StartThis is a beta
The lessons are usable now. Progress stays in this browser. Nothing on this site sends your formulas to a server.