Provide list of managed references while editing / creating a formula

When writing a formula where I need to use cross sheet references, I would love to have a list of the already created references on my sheet be available when I select "Reference Another Sheet". It could just be access to the already existent "manage references" list or could be divided based on the sheet that is being referenced.

Ultimately, I want to insert a cross sheet reference by clicking on a reference I've already created instead of having to load the source sheet and scroll to the correct column each time.

Sign in to vote!

Find more posts tagged with

Formulas

Idea Submitted

Comments

heyjay

I normally use a very short, easy to remember, and descriptive Sheet Refence name so I can easily type them as I create my formula. _Data _Name etc. But yes I also like your recommendation.

Samuel Mueller

I agree with heyjay on naming cross sheet references in an easy to remember format, so you can easily remember the reference name for future formulas.

But If you are looking for a an easy to access dropdown list of references you have already created, then yes that's a great idea.

Shawna Roskos

Thanks for the feedback! I agree, I try to keep my references concise and clear, but I have had a couple sheets with 20+ references. With so many to keep track of, I felt like having a list would be the easiest way to add them into formulas.

Quick Links

Trending ideas

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…
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…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.