Free tool · no sign-up

Smartsheet formula converter: paste a formula, watch it run in Wisegrid.

Wisegrid is [Column]@row-native: the same-row references Smartsheet uses work here unchanged. Paste a Smartsheet formula below and see exactly how it lands. Your formulas survive the move.

Start your free trial, keep your formulasSee what carries over ↓
Try one:
In WisegridRuns unchanged
=IF([Status]@row="Done",1,0)
  • Same-row [Column]@row is preserved exactly. Wisegrid evaluates @row natively: it expands to this row internally, so the formula reads and runs just like it did in Smartsheet. No rewrite.
  • Excel, for contrastIn Excel, there is no @row. You would pin each reference to an explicit row number (or wrap it in INDIRECT), and it stops auto-following the row it lives in. Wisegrid keeps the @row dynamism Excel drops.
Start free trial and bring your formulas overSame price you already pay, with more of everything. The importer is included. 7-day free trial, no credit card required, cancel anytime.

Why your formulas surviveYou're not translating into a foreign syntax

The same-row reference just works

Smartsheet writes the current row as [Column]@row. That is exactly how Wisegrid writes it too: the engine expands @row to the row the formula lives in, automatically.

So a formula like =IF([Status]@row="Done",1,0) comes over verbatim and evaluates the same. Nothing to relearn.

Your lookups come with you

VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, and XMATCH all ship in the Wisegrid engine, alongside 100+ more functions.

If you paste something the engine doesn't yet evaluate, this tool tells you honestly instead of rendering a wrong value. A formula you can't trust is worse than one you know to check.

Cross-sheet, without the ceiling

Smartsheet makes you create a named {Reference} through a picker, and caps how many you can have per sheet.

Wisegrid lets you type a cross-sheet reference inline as [Sheet]!range: no picker modal, no 100-reference cap. Your imported references resolve to your real sheets.

The side-by-sideWhat actually carries over when you move

Your syntax and your lookups come with you. Where Wisegrid pulls ahead is cross-sheet references and what survives the day you leave. The Smartsheet limits below come from Smartsheet's own documentation.

Formula capability
Smartsheet
Wisegrid
Same-row [Column]@row references run unchanged
Yes
Yes
VLOOKUP, INDEX, MATCH, XLOOKUP, XMATCH
Yes
Yes
Type cross-sheet references inline, no picker modal
No
Yes
Cross-sheet references per sheet1
100
500
Formulas kept when you move off the tool
Values only on export2
Imported and re-run
Self-serve Smartsheet importer that flags unclear formulas
No
Yes

1 Smartsheet caps cross-sheet references per sheet: "A sheet can include no more than 100 distinct cross-sheet references" (Smartsheet cross-sheet references documentation). Wisegrid allows 500.

2 Smartsheet's own export to Excel or Google Sheets: "Formulas aren't preserved due to the differences between Excel and Smartsheet formula syntax" (Smartsheet export documentation). Wisegrid's importer brings formulas across and re-runs them, flagging anything unclear for review instead of dropping it.

Start free trial on Wisegrid

Bring every formula over at once

This tool checks one formula. The importer does your whole workspace (sheets, formulas, and attachments) and shows you exactly which formulas (if any) need a second look, so nothing changes behind your back. Same price you already pay.

Import from Smartsheet
Frequently asked
How do I convert a Smartsheet formula to Wisegrid?
You usually don't have to. Wisegrid is [Column]@row-native: the same-row reference Smartsheet uses works in Wisegrid unchanged. Paste your formula above and you'll see it preserved as-is. The only parts that adapt are whole-column and cross-sheet references, which Wisegrid resolves to your actual sheet when you import.
Does Wisegrid use the same formula syntax as Smartsheet?
For the reference that matters most (the current row), yes. [Status]@row, [Hours]@row, and the [Column Name] bracket syntax are all native to Wisegrid. That is why a Smartsheet formula like =IF([Status]@row="Done",1,0) comes over and runs without a rewrite.
What about Excel? Is the Wisegrid formula the same as Excel?
Not quite, and that is a good thing. Excel has no @row, so an Excel equivalent has to pin every reference to an explicit row number (or wrap it in INDIRECT) and loses the ability to follow the row it lives in. Wisegrid keeps the @row dynamism Excel drops, so your formulas keep working as you add and move rows.
Does Wisegrid support VLOOKUP, INDEX, MATCH, and XLOOKUP?
Yes. VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, and XMATCH all ship in the Wisegrid formula engine, alongside 100+ other functions. If you paste a function the engine does not yet evaluate, this tool flags it honestly as needing review rather than pretending it works.
Will my cross-sheet references survive the move?
Yes. A Smartsheet {Reference Name} resolves to your target sheet on import. And in Wisegrid you can also type a cross-sheet reference inline as [Sheet]!range, with no 100-reference cap and no picker modal to click through.
Is this tool free?
Completely. There is no sign-up, no email gate, and nothing leaves your browser. The conversion runs entirely on this page. When you are ready to bring your sheets over, the Smartsheet importer does the same translation across your whole workspace.

Your formulas already speak Wisegrid.

Bring your Smartsheet workspaces over and pick up exactly where you left off: same grid, same formulas, same forms. Nothing new to learn Monday morning, and more of everything at one flat price.

Start free trial on WisegridSee how import works →

Want the full picture? See how Wisegrid compares to Smartsheet →