Not IS Blank or IS Text formula to mark a symbol

hsway
hsway
edited 11/30/21 in Formulas and Functions

Use Case:

I would like a cell to change symbols (red for example) based on whether or not a given row has text (any text).

I've tried

=IF(ISTEXT([What should we stop doing?]@row, "Red")))

Returns UNPARSEABLE

I've also tried

=IF(NOT(ISBLANK([What should we stop doing?]@row, "Red")))

Returns INCORRECT ARGUMENT.

Surely there is something I am doing wrong?

Answers

  • Hi @hsway

    Are you looking only for text, or if there is any content at all in the cell? If you're just looking for any content, I would do the following:

    =IF([What should we stop doing?]@row <> "", "Red")

    <> "" says not blank

    If you're specifically looking for a cell that is only text values (versus numerical), then you can use the ISTEXT, like so:

    =IF(ISTEXT([What should we stop doing?]@row), "Red")

    Notice that there is a closing parentheses after the @row ) before the comma and "Red". This is why you were getting an error.

    Keep in mind this will only ever return a Red ball or Blank cell. Do you have other statements you want to return? For example, should it ever be Green or Yellow?

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Hey Genevieve,

    Your first suggestion worked out. I did =IF([What should we stop doing?]@row <> "", "Red", ""). Thanks

  • Wonderful! I'm glad I could help.

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!