Creating multiple ranges without formula
I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-programs and then up to the overall program.
Is there any way that I can go into an individual sheet, select a column and then name it as "range x"?
I am needing to create a number of INDEX/MATCH statements to bring various data into different sheets and it is very tedious having to do this sheet by sheet in the target sheet.
It would be so much simpler to just create all the ranges and then just type out the formulas, rather than needing to start the formula, wait for the reference window to load the source sheet, find and select the column/s for the range, rename the range for the INDEX range, then do it again for the MATCH range.
Any assistance would be appreciated.