Link from a cell-reference and make the answer a column formula
When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value appear on every line of a column (so that reports across with the info across industries can be sliced differently). I created a helper column to bring in the cell thinking I could create a column formula to always bring back the absolute value of that cell, but you can't make a column formula from an absolute.
I am open to other ideas. I know I can create an automation, but ideally I would like to use a formula so that I can add the new column and formula at my blueprint level and not have to touch each active project after we push it out through control center.
Ideas?
Answers
-
What if you put the link to the Industry value in the sheet summary. Then made your column formula reference the sheet summary?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!