You can make changes to your reference directly in the formula, or, you can use the reference manager.
Edit the formula
You can edit a reference directly in your formula without opening the Sheet Reference Manager.
- Select the cell that contains your formula. A summary of the formula appears in the cell.
- Click the name of the reference that you’d like to edit.
- You will see a link to Edit Reference. This will open the reference another sheet dialog where you can change the reference name or choose a new sheet or cell range.
When you edit a reference, all its instances in the sheet will update in real-time. If want to keep the structure from a formula in your sheet but want to change the range, it’s better to delete the text from the current reference and create a new reference.
Edit in the reference manager
In the sheet reference manager, you can see and modify all cross sheet references and cell link references in your sheet. To open it, right-click any cell in your sheet and select Manage References.
The cross sheet references manager opens by default, but you can switch to the cell link references manager using the left panel. Learn more about cell links.
Use the following table for details on each of the features in the cross sheet references manager:
Feature | Action | Tips |
---|---|---|
Feature Search | Action In the search list… box, type keywords to find references you need to use. | Tips Use a conventional naming structure for your references, such as sheet name_columns referenced. |
Feature Filter | Action Open the All References drop-down list to set the filter to Active, Processing, Broken, In Use, or Unused. | Tips Filters help you find, categorize, or review references.
|
Feature Create | Action To create a new reference, select + Create. | Tips You can use this reference when you create new formulas. |
Feature Edit Reference | Action Steps in editing references:
| Tips If the reference you are editing is in use, all its instances in your formulas will be updated. |
Feature Duplicate Reference | Action To make a copy of a reference, select Menu > Duplicate Reference. | Tips The name of the duplicate reference will be Copy of_original reference name. |
Feature Delete Reference | Action To delete a reference, select Menu > Delete Reference. | Tips If the deleted reference is in use, the formulas may return #INVALID REF errors. |
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.