Column Formula, but accesses different sheets

SherryFox

I am creating a Metrics sheet. Now I am working on my # of Records column (circled).

The first formula (for TDL-03) is: =COUNT({TDL-03 - Certify Access_TDLs}).

And the 2nd formula (for TDL-06) is: =COUNT({TDL-06 - Certify Access_TDLs})

Is there a way these formulas can be dynamic in some capacity, and reference the far left Column, which contains the TDL #? I know I could do this in Excel

Darren Mullen

@SherryFox

Since you are creating ranges for each TDL… you'd have to have an if statement to check the TDL number on the row then count the corresponding range.

Not sure that really gets you anywhere though because you'd have to write each combination out. I think you are trying to select the range name dynamically, which can't be done in Smartsheet.

if you have TDL columns in another sheet next to each other, you could create a 2D range and then dynamically select them based on an index column. But that's fragile because any new columns inserted or change of column order could break that.

SherryFox

Thanks @Darren Mullen