Sheet Column for Missing Attachment

Jim Percival

Hello,

I'm pretty new to creating functions for columns and wanted to see if there is a way to have a Missing Attachment column displaying Yes or No depending on the attachments themselves for the row? It seems like the attachment "paperclip" itself can't be leveraged as a filter in the Work Insights graphs.

Thanks!
Jim

jmyzk_cloudsmart_jp

Hi @Jim Percival

You can use a workflow automation triggered when an attachment is added or changed.

Published Demo Sheet

https://app.smartsheet.com/b/publish?EQBCT=6b548a43fe034e4ab040d74b0405e6d0

Limitation

This method's limitation is that if attachments are deleted, the Has Attachment checkbox remains and can not be used for past rows.

You need to use API to deal with the limitation, i.e., to determine if a row has attachments and, if so, flag it by changing the Has Attachment column of the row.

(

Jim Percival

Hi @jmyzk_cloudsmart_jp

This is very cool, I appreciate your response! I will give it a try, but I understand the limitation means it won't work exactly the way I was hoping for it to.

Thanks