Smartsheet Formula Reference to another sheet
I am creating several different budget sheets. In these I want to reference one reference sheet.
For example in my current sheet:
I am looking to say If Column names: HI Rate Code = HR Rate Code from sheet name: Reference Guide then bring over the # listed in Sheet Name Reference Guide, Column Name: HI Rate Amount.
Help :(
Answers
-
I use Vlookups but you will not be able to move columns around if you do since it is based on the column number that it is in the array - https://help.smartsheet.com/function/vlookup. You can also use Index and Match to avoid that but it's just something I'm not used to - https://help.smartsheet.com/function/match.
This is what I'd think your vlookup would look like: "=vlookup({{HI Rate Code}}, {{Array from Other Sheet starting with column HI Rate Code}}, {{Column Number for HI Rate Amount}},false)"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!