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
-
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.