Simplify a Formula
Answers
-
No. Im making a helper column...so we have 30 conveyors spread throughout three areas. I'd like to have a formula that says which plant each conveyor belongs in, which will then be used in a sheet summary to say...so many conveyors in area 1, 2, and 3 have been inspected...
-
"I'd like to have a formula that says which plant each conveyor belongs in"
What is the logic that determines this? Do you have a master list of all conveyors and where they belong, or is there some type of indicator elsewhere on the sheet?
-
Paul, Its a master list that I have on a spreadsheet.
-
Paul, should I make a Helper sheet and then Vlookup......
-
If you already have a master list of all of the conveyers and where they should be located, then you can use a VLOOKUP to reference the table. I personally prefer INDEX/MATCH as it references (potentially) fewer cells and holds up better to adjustments in the source data layout.
=INDEX({Master List Location Column}, MATCH(Conveyer@row, {Master List Conveyer Column, 0))
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!