Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
Um. There is no attachment. Can you add it to a new comment so we can see it?
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.
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.
well its not really an attachment it is copied into a comment field.
In your RGB Symbol column add this formula:
=IF(FIND("theemail@address.com", [Comment Column]1) > 0, "Green", "Red")
Hope that works for you!
