RETURN TEXT VALUE FROM ANOTHER SHEET
KempenUSA
✭✭✭✭
What formula can I use to only return the TEXT Value displayed on another sheet in a specific cell? I do not want to use the link function.
e.g.:
if the cell contains: WO#: 1278
I want a formula that will bring over that "WO#: 1278 into a different sheet.
Answers
-
@Andrée Starå Hi Andree, can you please with this one? Thx
-
@KempenUSA If you don't want to use a direct Cell Link, you'd have to have a way to lookup the value by a unique ID and then use and Index() Match() formula combo.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!