trouble shooting a range

Billymacdo

a series of references have become invalid?
not sure what has caused this but i want to walk thru the formulas and make the corrections
how do i see a range? i see it being called in the formula but i cant figure out how to go to the range and be sure its still valid

Matt Lynn-PCG

@Billymacdo While you're in the formula (or click edit column formula if it's a column formula) if you click the {range} reference it'll show "edit reference". Click that and wait for it to load and you'll see the selected range. The type of formula it can be more/less troublesome. Example if you're using a vlookup or other formula where the range is more than one column, and someone changes the order of those columns it can mess up the formula. Rather use index(match()), index(collect()), or some other formula so each column is it's own range… it'll be easier for things not to become broken. If you're the only person using the data then it's prob ok.

Billymacdo

i dont see "edit reference"

Courtney S.

When you've got the formula open, you need to click into the part of the formula that is the Reference, to see the edit reference option. Alternatively, you can edit all your cross-sheet references by right-clicking on any cell and then choose "Manage references" from the menu. See this help page:

View, modify, or delete cross sheet references in formulas | Smartsheet Learning Center