Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Assigning a number with a formula
Comments
-
You have to include the second conditional insed the first set of paretheses.
=IF(Request1 = "Greg", 1, IF(Request1 = "Bill", 2))
-
Tiare,
You could also create a List of people in ta Dashboar area at the top of the sheet with a number in the ajacent cell and then use a Lookup function rather than nesting a load of ifs. You will find that that would probably be quicker and have less overhead on the sheet performance.
-
Hi, I tried to use this formula and it works for my purpose. However, in certain cases the number assigned should start with a zero and SS ignores it. Is there a way to solve this issue? Thanks.
-
Francesca
If you used the Formula method then in the the formula enter "02" or if that does not work tru "'02".
The apostraphy should force it to treat it as Text.
Note if you sort data in this column and some entries are Text and some are Numbers you may get what appears to incorrect sorts.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives