Header Formatting for Formulas

How do you convert the first row to mirror the header row?

The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we type in the header name, we receive error messages as if the sheet cannot find the information.

We are thinking that there is a feature that mirrors the headers that actually "registers" the header in the system allowing for a pull of accurate information. (This is an assumption)

We typed in Scope Statement and received an invalid error sign.


  • Julie Fortney
    Julie Fortney Overachievers

    Is the template you're using from the Smartsheet template gallery? If so, can you provide a link? I'm not sure why you would need to list the column names in a header row, so viewing the template might help.