Collect Value from 3rd Column
Hi Team,
I am working on a Scenario where I have to pull the value from the 3rd Columns, I have 2 Smartsheets A and B. In Smartsheet A I have Unique Value Column as Request # there is another field "Course Name" Which Consists of Multilple Values as shown in below screen shot "Cisco HyperFlex Management and Operations Workshop" and the other value is "Cisco UCS Management and Operations Workshop".
In the other Smartsheet B I have both the columns as in Sheet A but there is Column Course date in Smartsheet B, My requirement to fetch the Course date in Sheet A if Values of both the columns matches.
The Only problem I am facing is that there are multiple values in Course Name, I am using the below formula
=JOIN(COLLECT({Supplier Registrations Range 5}, {Supplier Registrations Range 2}, [Request #]@row, {Supplier Registrations Range 4}, OR(@Cell="Cisco HyperFlex Management and Operations Workshop",@Cell="Cisco UCS Management and Operations Workshop"))
but this is giving me error of Unparessable, Can anyone suggest here.
Answers
-
Lets start with the error itself and see what happens...
"@cell" should always be lower case. You have the first letter capitalized in your formula. What happens when you fix that?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!