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, pleaseVisit the Current Forums.
Drop down selection box legend
It would be really nice if when you set up a multiple choice slection box and you are using acronyms, that you could put a short description by each. I'm always trying to make columns narrower to allow more columns on the screen without having to use a slide bar to see more. I set up one column that indicates which department is responsible for the task. I gave each a 2 letter acronym. I constantly have people asking me what each acronym stands for. If when they dropped down the list, they could see a desription to the right that would reduce one more question and we would get better accuracy and quicker selection. Is there a way to do that now and would it be hard to do? Other option would be to have pop up comment boxes where you could put the legend. Pop up comment boxes would in general be very helpful for navigatiing through a Smart Sheet.
Comments
-
Shaine Greenwood Employee
Hi Daryl,
You might consider putting your acronym description in your dropdowns (e.g. "P - Published"), or instead of using acroynoms, typing the words out in their entirety to avoid confusion.
If you need to use the acronyms for a different purpose, you can use a formula to populate the acroynm in another column, such as =IF(Status1 = "Published", "P")
Categories
I guess you forget to use AND( ).<\/p>
For example, <\/p>
- IF([Total Value to User Score]@row = <3.8, >4.7, \"Mild,<\/li><\/ul>
should be<\/p>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>
However, the following would be more straightforward.<\/p>
- =IF([Total Value to User Score]@row >= 4.8, \"No Pain\", <\/li>
- IF([Total Value to User Score]@row >= 3.8, \"Mild\", <\/li>
- IF([Total Value to User Score]@row >= 2.8, \"Moderate\", <\/li>
- IF([Total Value to User Score]@row >= 1.8, \"Very Severe\", <\/li>
- IF([Total Value to User Score]@row < 1.8, \"Extreme\", \"//www.santa-greenland.com/community/discussion/7059/\")))))<\/li><\/ul>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>