Referencing Another Sheet Formula For Text
I added a column in a sheet that is sourced from another sheet...it's for text not numbers. Which formula would I use for this one? The source correlates to the site name...I'm a little stuck. Thanks in advance!
Answers
-
@laura.sandoval you have a few options, such as VLookUp, Index and Match, etc, based on how you are wanting it to be utilized and how the formula will trigger.
If you can provide a few more details about the source sheet, the lookup value or matched column that will allow the lookup, I think either myself or another member of the community would be able to get you a formula.
Here are some learning resources on those functions.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Hello thanks for your reply! I am stuck with the formula. This is what I have so far (picture attached). The sheet I am referencing (Master Site Contacts Source) has a list of all the sites as well as their sources...how can I fix the formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!