Does Wisegrid have cross-sheet references like Smartsheet?
Yes. You pull a value from another sheet by typing a reference right in the formula: =[Sheet2]!A1. There is no separate feature to enable and no add-on tier. It is part of the formula engine on every plan, including Free.
How do I reference another sheet in Wisegrid?
Bracket the sheet name, then point at an A1-style range: =[Sheet2]!A1 for one cell, =[Sales]!B:B for a whole column, =[Sales]!A1:F100 for a rectangle. Type it straight into the formula and it binds when you save. As you type = and open a bracket, a typeahead suggests the sheets you can read so you do not have to remember exact names.
Do I have to create a named reference first, the way Smartsheet makes you?
No. There is no "Manage References" dialog and no predefined named range to set up before you can use it. You write the bracketed [Sheet]!range inline and it binds on save. That is the whole flow.
How many cross-sheet references can I have per sheet in Wisegrid?
The per-sheet cap on distinct cross-sheet references is 20 on Free, 200 on Pro, and 500 on Business. These are per sheet, not per account, and they are room to breathe rather than daily friction.
What happens if I hit the cross-sheet reference limit?
A save that would add a new distinct reference beyond your tier cap is blocked with a clear "limit reached" message, while saves at or under the cap go through normally. Removing references frees the count back up, and a sheet that is already over the cap keeps reading and resolving fine. Only net-new references are what get gated.
Can I reference a sheet in a different project?
Yes. Within the same project you write =[Sheet]!A1. To reach a sheet in another project you add the project in front: =[Project][Sheet]!A1. Both bind inline on save, with no dialog either way.
Do cross-sheet references update when the source sheet changes?
Yes, they resolve live. When the source sheet changes, the dependent sheet pulls the fresh values and recomputes, and it also recomputes whenever you open or reload it. You are not babysitting a copy-pasted snapshot that quietly goes stale.
Can someone see data through a reference to a sheet they cannot access?
No. You can only bind a reference to a sheet you already have read access to, and that access is re-checked at read time, not just when the link is created. If you lack access, resolution returns a single "Sheet not found or no access" message that never even reveals the sheet exists, so a viewer never leaks the underlying numbers.
Will my Smartsheet cross-sheet references survive the import?
Yes. The importer translates each Smartsheet {Reference Name} into a bracketed [Sheet]!range (or [Project][Sheet]!range for a different project) pointed at your real target sheet in Wisegrid, so the formulas resolve after the move with no manual rebuild.
Does Wisegrid support VLOOKUP and SUM across sheets?
Yes. Any function can take a cross-sheet range as an argument. =VLOOKUP([Email]@row, [Customers]!A:F, 3, FALSE) matches a row on another sheet, and =SUM([Q1 Sales]!B:B) totals a whole column from one. The same [Column]@row syntax you used in Smartsheet works alongside it.
What if two projects have sheets with the same name?
When a sheet name matches more than one project you can read, Wisegrid asks which one you mean instead of guessing. It shows the candidate projects so you bind the exact sheet you intended, rather than silently picking the wrong one.
Is the cross-sheet syntax the same as Excel?
The range after the ! reads like Excel (a cell such as C2, a column such as B:B, or a rectangle such as A1:F100), but Wisegrid brackets the sheet name as [Sheet]!range. Bracketing is why a name with spaces, like [Q1 Sales], just works without quoting.