Test against Attachments column within formulas

Lauren Cain

How would I reference the Attachments column in writing a formula? For instance, if I want one column's text to display "Attached," on the condition that there are attachments to that row?

 

Or if there are better ways to do it that would be great. I have a "Resource Locations" sheet. In each row there will be the name or description column and then a column for where the resource is located. This can be URLs, documents or just a text description. i'd like to use the Attachments column but it is hardly notceable so I want my Resource Location column to at least say "Attached" if the resource for that row is an actual attchment on the row.

Brett Evans

I don't think you can reference the special cells on the left with the formulas.  You have to use the API to get to them:

 

http://smartsheet-platform.github.io/api-docs/#

https://github.com/smartsheet-platform/samples/tree/master/php/3-Attachments

 

Which is a whole 'nother level.

 

 

Lauren Cain

Cool - playing around with the API could be a nice little side project...

Judah Karkowsky

+1 on this need.

Sergiy Gavrylyuk

+1

Keith Tham

+1 Vote please

Jsloan

+1 Vote Please

Andrée Starå

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD