Question About Symbols Based on Text
Justin Tackitt
✭✭✭✭
Hello  I am trying to figure out a formula to place the red circle symbol if the cell prior contains the the word "red" and a green dot if the cell contains the word "green". I tried to figure out the formula based on one color and didn't get very far. Column name for the cell with the word "red" or "green" is B&E Management  Staffing.
Any help would be greatly appreciated!
=IF(FIND("green", [B&E Management  Staffing]1), "Green")
Best Answer

Disregard  I will use =[B&E Management  Flow]@row to auto populate the symbol.
Thanks!
Answers

Disregard  I will use =[B&E Management  Flow]@row to auto populate the symbol.
Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 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!