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

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.