Automation between two sheets
Hi All,
Hope you're all well.
I am wondering if you can help me. I have two separate sheets - one of them is the tracker and the other one is the RAID log. There's one column that's same for both sheets - it is a job number.
All the issues gets submitted to the RAID log through the form.
Is there a way to create any sort of sheet crossing, formula, automation, so when the issue with the job number appears on the RAID log, Smartsheet automatically highlights or flags the row with the same job number in the tracker?
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.
But you would just have the column in the other sheet and make it "=vlookup({{Job Number}}, {{Reference for RAID Log}}, {{Number of Column for Issue}}, false)"
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives