When setting up a new smart sheet with named ranges, how do I get the Account number to print in front of the Account description that will automatically expand and contract when needed? Is there a .colspec that can be used or even just print the generated column?

Hi Paul,

In cell B1 of a SmartSheet, right-click the cell and from the pop-up menu, choose 'Make ShowAccounts'. This will insert text into cell B1 that will unsuppress column B when printing.

Another method is to insert a new column to the left of the description that simply prints the account number, though this would only work for Expanded smart sheets rather than Collapsed.