Renaming Columns

Jeff Hoelzel

Is there a way to rename multiple column headers using a control sheet inside or outside of Smartsheet? For example, we have 36 budget sheets set up in Smartsheet. The columns are named either Budget or Actual by month. When we post Actuals, we have to manually rename each current month column to read, Actual. For this past month we had to rename the July fiscal year 2021 columns on all our budget sheets from "Budget Jul FY21" to "Actual Jul FY21." We use a main sheet with linked data to control filtered row data in all the budget sheets, but we are not able to link the column headers. The renaming of the columns does affect our reports, but that is another issue.

David Joyeuse

Hi @Jeff Hoelzel

As far as I know, there's no way to rename columns other than do it manually.

In your case, you should definately create an Actual column with some formula within it so it automatically displays the actual budget such as:

=INDEX({Budget Range},1,MATCH(AND(YEAR(DATE(@cell))=YEAR(TODAY()), MONTH(DATE(@cell))=MONTH(TODAY())),{Date Range},0)

The Budget Range being all your columns you want to test.

The Date range being a single line with MM/1/YY typed in it so we can identify the column you need to report.

Also the 1 for the line may change as well depending on what line you want to display each time.

But screenshots would definately helps here to solve this :)

Hope it helped!