Add the excel function for "Named Range"
N
Nathan Jarasius
This is one of the best hacks to write formulas. That is far easier to reference cells and ranges in formulas so you can read them in plain language rather than a cell reference.
You can write more complex formulas and collaborate better with other people if they didn't write the formulas themselves.
And the named ranges dynamically resize so you don't break formulas when new data is added.
N
Nathan Jarasius
You guys just released the new feature to "hover over formula and read the column name" which is awesome so good time to refresh this request.
This is now one powerful extension you could make is to display the name of the reference column in the formula e.g. "created_date". That way I don't even have to hover over to read the formula! And by definition the reference is locked because it's the column name. Everything will still work the same way but when I select the relevant column it will display in the formula as created_date instead of Sheet1!$A;$A. If I wanted to sum up MRR it could =SUMIFS(MRR,created_date,B2)
That's one step closer to defining my own "Named Ranges" to make formula writing and reading next level. If I could then give cell "B2" its own name as "this_month" the formula could be updated to:
=SUMIFS(monthly_sales,created_date,this_month)
Boom. No hovering. No guessing. Read the formula in natural language for everyone.