Collating Attachments from Multiple Smartsheets

Asha Rajesth

Hi

We use Smartsheet to capture customer requirements and each requirement sheet has attachment links stored under the attachment icon which is used for internal and external stakeholders.

Since we have multiple projects running at the same time we created a consolidated requirements sheet using index and match formula.

We want to collate the attachments under the attachment icon too. Is there a formula or API that we can use to collate it?

Thanks & Regards

Asha

Asha Rajesth

Hi

We use Smartsheet to capture customer requirements and each requirement sheet has attachment links stored under the attachment icon which is used for internal and external stakeholders.

Since we have multiple projects running at the same time we created a consolidated requirements sheet using index and match formula.

We want to collate the attachments from the attachment pane on the left side of a smartsheet to a Master Smartsheet. Is there a way to this on smartsheet?

Thanks & Regards

Asha

Genevieve P.

Hi Asha,

Currently there is no way to bring an attachment across from one sheet into another by using a formula.

One way to bring these attachments together across a number of sheets would actually be to create a Report (see here) since this will show attachments and you can download them directly from the Report without opening the underlying sheet. Would that work for you?

If you need help building out this report, it would be useful to see a screen capture of your sheet (but please block out any sensitive data).

Thanks!

Genevieve

Andrée Starå

Hi Asha,

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could maybe use the Smartsheet API.

Is that an option?

Another option would be to download all attachments and then add them to the other sheet.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Asha Rajesth

Hi Genevieve,

Thanks for your response.

I tried with the report, it doesn't collate the attachments from the attachment pane. I need to put the link in a separate column to get them collated.

Regards Asha

Asha Rajesth

Hi Andree

Thanks for you response. I have submitted the request for enhancement.

Can you please help me with the Smartsheet API, how do I go about getting that done

Regards

Asha

Andrée Starå

@Asha Rajesth

Happy to help!

More info about the API here.

https://developers.smartsheet.com/