Named ranges in Proton Sheets
I use named ranges extensively in any spreadsheet I create. They supercharge things like VLOOKUPs or data validation with a list of possibilities.
Rather than entering a fixed cell reference, I create separate data source or menu option sheets and name the ranges. I then reference those ranges in my lookups or data validation. The data source lists can be modified, sorted, formatted, etc independently of the cells or tables that reference them, and it can be done without having to actually edit the lookup formula or data validation setting.
Anonymous
shared this idea
-
Bit Of A Tinkerer
commented
Just to add to this, it'd be nice if you could make the named range function dynamic/ auto-tracking.
This could either be done via:1) The Google Sheets Method (probably more user-friendly for beginner users) - named ranges automatically shift if you move the named area (column/ row) around (Eg user named A2:A999 as "Test Range" > User manually moves A:A to D:D > "Test Range" automatically updates to D2:D999.
2) The Libre Office Calc Method - allowing users to use dynamic/ tracking formulae for the ranges. Eg =INDEX($Helper.$2:$200, 0, MATCH("Account", $Helper.$1:$1, 0))
-
rick
commented
Named Ranges are such a core necessity for ease and clarity in writing functions and for maintenance of complex calculations etc it's hard to understand why proton sheets was ever released without it. Currently it's the equivalent to trying to write code without being allowed to use variables. Nuts. Baffling. This app should not even be in beta testing yet - it's not finished!
Proton sheets completely fails as a replacement for any of the others - excel, google, libreoffice - without this most basic core functionality. I mean the list of bugs and clunky slow behavior is long but come on - no named ranges? As a coder i well know how simple this is to implement... it's just a variable pointing to a list. Get it done please! -
Anonymous
commented
To clarify, if you select Data > Data validation, there’s a button to add a named range. It doesn’t. It adds a data validation rule. This request is for the type of named range feature like what’s available in Excel or Google Sheets.