How to Generate - Unique value using Index formula in the Columns Instead of Rows
Fruits_Master_List |
| S. No | Fruits Index |
---|---|---|---|
Apple |
| 1 | Apple |
Mango |
| 2 | Mango |
Pineapple |
| 3 | Pineapple |
Cherry |
| 4 | Cherry |
Mango |
|
|
|
Pineapple |
|
|
|
Cherry |
|
|
|
Pineapple |
|
|
|
Apple |
|
|
|
Mango |
|
|
|
'=IFERROR((INDEX(DISTINCT(COLLECT({Fruits_Master_List}, {Fruits_Master_List}, @cell <> "")), [S.No]@row)), "")
I am using the above-mentioned formula - to generate the fruits unique value
BUT I WANT THE OUTPUT IN THE COLUMNS instead of ROW
S. No | 1 | 2 | 3 | 4 |
---|---|---|---|---|
Fruits Index | Apple | Mango | Pineapple | Cherry |
Let me know if this is possible ?
Answers
-
You would put your numbers across the top row and then you would reference those cells. It is the same exact concept as the vertical list.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!