Being able to attach files to rows in Smartsheet is fantastic. You can then share these in reports, notifications, update requests and more. And you can uploads lots of attachments to one single row. But if you’re working at scale, if you want to see what attachments are in a row or how many, you need to click the attachment icon – and then it shows you the top 10 attachments. But what if you have more? You have to scroll though the attachment panel on the other side. And what if you’re looking for a specific attachment on a sheet? Searching within the sheet doesn’t work…
And what if someone submits a form with attachments? Can you quickly see if they have attached all 5 documents you asked for and named them correctly. Um, no.
So wouldn’t it be great if you could see how many attachments are on each row, and, imagine this, the names of all the attachments, including the file types. In your sheet. So you can see and act upon that information. And set up formulas and rules to alert you if attachments are missing or wrong.
Well, fancy that. The Prodactive team thought exactly that and came up with a cracking solution that does just that. It adds two columns to your sheet and then update these each tie the number of attachments changes and also when the names of attachments change. Bravo!
