Scenario: multiple individual sheets copy a single row to another sheet based on a trigger.
Is it possible to include the Originating Sheet URL when rows are copied to a different sheet?
I hope you're well and safe!
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi @Andrée Starå ,
Unless I am mistaken, all of those suggestions, while helpful, are manual entry of the URL.
I tried this morning to get the URL from a report, which has the link, but it does not export it to Excel. I need to match it up to a report.
Thank you for your assistance!
Happy to help!
Yes, you're correct. They are manual. The only possible way to get it automatically would be to use the Smartsheet API or a 3rd-party integration.
Is that an option?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
The API might be an option but I would need crash course on how to do that.
In short term, I will have it send notification with link and data and try to smash that into a report.
Also can use Has Smartsheet/Missing Smartsheet based on returned data without a direct link but link would be so much more helpful.
How many sheets are we talking about?
This will happen once per sheet and quantity of sheets created is dependent upon seasonal busy periods but could be from 0-20 per day. Avg maybe 5/day.
I would roll this info into a weekly report done in Excel (master data comes from a different system).
I can have the sheet creators manually add the URL and will discuss that with them, however, they already do a lot of work to setup the sheet and I hesitate to add more tasks.
What 3rd party integration might provide the Row URL?
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.