Options
Laura Melendez ✭
04/09/20 in Formulas and Functions
Hi im trying to archive that is this statement =IF(Price1>Price2,"Green Arrow")
but not sure how to add the green arrow of the symbols is there a way?
0 · Share on FacebookShare on Twitter
Ryan Nix ✭✭
04/09/20 Answer ✓
Options
Hi Lauara,
This took me a hot moment too - here's a link to the available symbols and what you'd put in the =IF statement: https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column
So your formula would be =IF(Price1>Price2, "Up") depending on which type of symbol you're using.
5 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
Options
Another quick way to see what text value needs to be used to generate the symbol is by looking at one of the cells in the Symbol column. It should have a dropdown arrow on the right of the cell. If you click on that dropdown arrow, it will show what options can be selected and includes the text values for each.
5 · Share on FacebookShare on Twitter
Answers
Ryan Nix ✭✭
04/09/20 Answer ✓
Options
Hi Lauara,
This took me a hot moment too - here's a link to the available symbols and what you'd put in the =IF statement: https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column
So your formula would be =IF(Price1>Price2, "Up") depending on which type of symbol you're using.
5 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
04/09/20 Answer ✓
Options
Another quick way to see what text value needs to be used to generate the symbol is by looking at one of the cells in the Symbol column. It should have a dropdown arrow on the right of the cell. If you click on that dropdown arrow, it will show what options can be selected and includes the text values for each.
5 · Share on FacebookShare on Twitter
thanks!
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
04/09/20
Options
Hi Laura,
@Laura Melendez
One method i use sometimes is to use a formula and reference the symbol and then it shows the text for it.
Something like.
=Symbol@row
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
04/09/20
Options
Happy to help! 👍️
0 · Share on FacebookShare on Twitter
KarinaG ✭
11/02/22
Options
Hello, I am trying to add the color gray to my drop down... not sure how to use the formula listed above for this. Help would be really appreciated since it's a time sensitive ask.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
11/03/22
Options
Hi @KarinaG
I hope you're well and safe!
Have you selected the Symbol option, including the Gray option?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on FacebookShare on Twitter
Help Article Resources
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.4K Get Help
- 90 Global Discussions
- 94 Industry Talk
- 400 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 46 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 251 Events
- 13 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
