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.
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives