Free tool · no sign-up

Smartsheet formula converter: paste a formula, see exactly how it lands in Wisegrid.

Wisegrid is [Column]@row-native: the same-row references Smartsheet uses work here unchanged.

Exported from Smartsheet? Their own docs say formulas are not preserved on export. You got values only. Paste one of the formulas you lost and see how it lands here.

Try it with your formula ↓
Try one:
In WisegridRuns unchanged
=IF([Status]@row = "Done", 1, 0)
  • Same-row [Column]@row is native here. This formula runs as-is.
  • 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.

The importer runs this same check on every formula in your workspace and hands you a review list of anything it could not convert, instead of quietly leaving dead values.

This one runs as-is. Start your free trial and bring the rest7-day free trial, no credit card. Viewers are free.

Bring every formula over at once

This tool checks one formula. The importer runs the same check on your whole workspace (sheets, formulas, and attachments) and hands you a review list of anything it could not convert, so nothing changes behind your back. Same price you already pay.

Your token is used to read and copy your sheets during import. It is stored encrypted, and you can revoke it in Smartsheet anytime. Prefer not to share a token? Import from your Smartsheet Excel export instead.

Import from Smartsheet

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 migration. 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 survive migrating in
Values only on export2
Imported, translated, 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
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.
What does [Column]@row mean in a Smartsheet formula?
[Column]@row is a same-row reference: it points at the value in that column on the same row as the formula. Both Smartsheet and Wisegrid use it, so a formula like =[Qty]@row*[Price]@row runs unchanged after you move. Wisegrid expands @row to the current row natively, with nothing to rewrite.
Which Smartsheet functions does Wisegrid not support yet?
Wisegrid evaluates 118 functions, including VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, XMATCH, NETDAYS, NETWORKDAY, and WORKDAY. The gaps a Smartsheet user actually hits today are NETWORKDAYS and @cell criteria: the importer flags formulas that use them for review instead of returning a value you cannot trust. And if you are wondering about FILTER, SORT, UNIQUE, LET, or LAMBDA: those are Excel functions. Smartsheet does not have them either, so they are not something you lose by moving.
Does Wisegrid support whole-column references like [Status]:[Status]?
Yes. Whole-column references such as =SUMIF([Status]:[Status], "Done", [Hours]:[Hours]) come over and resolve to your sheet columns on import. This tool shows example column letters in the preview and maps them to your real columns when you actually migrate.
How do I convert all my Smartsheet formulas at once?
Use the importer instead of this one-formula tool. Paste a Smartsheet API token and it translates every formula across your whole workspace, preserving same-row [Column]@row references and flagging anything unclear for review, so nothing breaks silently. Your token is used to read and copy your sheets during import, it is stored encrypted, and you can revoke it in Smartsheet anytime. Prefer not to share a token? Import from your Smartsheet Excel export instead.

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 →