Need help
![Manojlo](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/2019-11/01/5c/n015c28f06b11f7e4347b4bee71e7b434.jpg)
Manojlo
✭
Hello, i need some help to set up my smartsheet document. Please check photo i attached, so i have those 2 vertical column, in one column i write all Colors i need which should be picked manually and in other vertical column ID it should automaticly write number for that color. Friend of mine told me it can be done by function IF but i don't know how to set that. If anyone can help me will be much appreciate. Thanks.
Best,
Manojlo
Tags:
Comments
-
=if(boja@row = "White",1,if(boja@row = "Solid White Blend",2,if(boja@row = "Ash",3
Try the formula above. You can switch the 1 2 and 3 with the numbers you want, or even reference a table for returns.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives