Expliciting a sheet name with Strings

edited 12/09/19 in Smartsheet Basics

Hi all,

I would like to calculate the sum of elements in a column (say the 3rd columne) on another sheet.

The sheetname is in a column "NameSheet"

The following SUM("{" + NameSheet[1] + " Range 3}") does not return anything.

I know Excel has something like Indirect() and it would be SUM(INDIRECT("{" + NameSheet[1] + " Range 3}")) in Excel.

Could you help ?