Keep "Sheet Reference Manager" open after creating a new reference: create multiple references

I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each additional reference. It would be very beneficial to my workflow to keep the reference manager open after each addition.

Sign in to vote!

Find more posts tagged with

Sheets

functionality

Idea Submitted

Enhancement Request

Comments

DeAnna Masterson

It would be great to add functionality to allow users to open "edit references" and create and save more than one reference at a time.

If I was able to create multiple references within a sheet at one time it would save me a lot of tedious work. The sheet I am currently working on requires four rules per column (3 from one 1 sheet, 2 from another) for 24+ columns. I have spent hours (not hyperbole) adding references one by one.

Darcy Gibbs

This feature would save me so much time!

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…