Smartsheet Developers
https://developers.smartsheet.com/The official Smartsheet developer portal, blog, and developer resources.
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
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
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.