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
- 62.7K Get Help
- 376 Global Discussions
- 206 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives