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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives