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

akacc73
akacc73 ✭
edited 12/09/19 in Archived 2017 Posts

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 :o) 

 

 

 

 

 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Laura
    Laura ✭✭✭✭✭✭
    edited 07/06/17

    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

    · Share on FacebookShare on Twitter
  • steven.reed14881
    steven.reed14881 ✭✭✭✭✭

    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

    · Share on FacebookShare on Twitter
  • Laura
    Laura ✭✭✭✭✭✭

    Here is a link to advise you on Steves suggestion!

    https://help.smartsheet.com/function/lookup

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories