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.
