Formula to create a Symbol response based upon a text string in the Comment

I am attaching from my emails a specific email response to the comments. The email will always have the same email the address is from. I would like to create a column using a symbol and say..... If the following text string is listed in any comment related to that record and to show a green dot.

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Mike Wilday

Um. There is no attachment. Can you add it to a new comment so we can see it?

Debbie J

No sorry....In smartsheet ....I have a record line listing an invoice. When I submit the invoice I receive an automated email receipt from a specific email address. I go to that response and then outlook I attach(copy) that email response to the comments in smartsheet.

In a column on that record I would like to add a green dot symbol that it has been loaded to smartsheet based upon that unique email address.

Mike Wilday

As far as I am aware there is no way to determine whether information in an attachment that has been uploaded in in the attachment. You can't even check with a formula to see if there is an attachment in the row. I would suggest submitting a Product Enhancement Request.

Debbie J

well its not really an attachment it is copied into a comment field.

Mike Wilday

In your RGB Symbol column add this formula:

=IF(FIND("theemail@address.com", [Comment Column]1) > 0, "Green", "Red")

Replace "theemail@address.com with the email address you want to find.
Replace the "Comment Column" with the name of the column that contains the email address.
Change the Comment Column Row number (currently 1) to whichever row you are placing the formula in.
If your comment column does not have a space in the middle of the title - remove the brackets from around the name. I.E. CommentColumn1.

Hope that works for you!