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.
conditional formatting

Hello!!
Hopefully someone can help.... I would like to run a conditional formatting where I enter a number in column 1 and that will produce specific text in column 2
I can only see option of changing the cell colour and not having the condition produce a line of text
Thanks Celine )
Comments
-
You would need to use a formula for this.
Example:
=IF([Column Name]ROW# = "#", "SPECIFIC TEXT")
Place this formula in the column you want the Specific Text to show.
The length of the formula might be longer depending on the different options of text you want to show
-
If you need more than a few # to text combinations, a better option might be to use a lookup table. This will operate like a vlookup table in Excel, if you have used that functionality. This gives you more flexibility to add combinations, and can be less confusing/overwhelming that stringing a long formula together. You can probably find instruction on this by searching on this Community. If not, I can help explain it if needed.
Steve
-
Here is a link to advise you on Steves suggestion!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives