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
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 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!