Determine all of the workflows a user is assigned to/included in
之前内容的用户才会安静下来, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will need to replace them in the workflows. Is there an easy way to do this? Even just knowing what workflows someone is involved in would be VERY helpful. I was hoping the "Sheet Access Report" may provide that information, but it does not.
Any assistance is greatly appreciated!
Thank you!
Megan
Best Answer
-
Paul Newcome ✭✭✭✭✭✭Unfortunately there is no way to pull/generate a report for this. It is a very manual process.
Feel free to browse through the Product Ideas tab at the top of this page to see if someone has submitted the enhancement request. If they have, you can add your vote. If they have not, then you can submit it yourself and allow others to add their votes.
Either way, it would be great if you could post a link to the enhancement request here so that others searching for the same thing can easily add their votes.
Answers
-
Paul Newcome ✭✭✭✭✭✭
Unfortunately there is no way to pull/generate a report for this. It is a very manual process.
Feel free to browse through the Product Ideas tab at the top of this page to see if someone has submitted the enhancement request. If they have, you can add your vote. If they have not, then you can submit it yourself and allow others to add their votes.
Either way, it would be great if you could post a link to the enhancement request here so that others searching for the same thing can easily add their votes.
-
mgainey ✭Thank you@Paul Newcome! I appreciate your response/feedback!
-
Paul Newcome ✭✭✭✭✭✭
Categories
The Smartsheet API does not possess a native method to directly fetch or incorporate clickable row permalinks when you export a sheet to an Excel file. So, users need more intuitive, clickable links within their exported Excel sheets.<\/p>
To address this, I have implemented a workaround:<\/p>
(I used Smartsheet SDK to implement the workaround)<\/p>
<\/p>
Fetching Permalinks:<\/strong> The code interacts with the Smartsheet API to retrieve each row's permalink values.<\/p> Incorporating into the sheet:<\/strong> These permalink values are then populated into a designated column. When you export the sheet as an Excel file, you'll notice a column filled with URLs corresponding to the permalinks for each row in Smartsheet.<\/p> Making the Links Clickable:<\/strong> As a final step, to enhance user experience and ease of access, the code processes the Excel file to convert these plain URL texts into clickable hyperlinks. Thus, when users click these links in the Excel sheet, they're directed to the appropriate Smartsheet row online.<\/p> With the implemented code, users can easily navigate to Smartsheet rows directly from their Excel sheets.<\/p>![\"export](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/PP3VBW3I0K76\/export-to-excel-with-row-permalink.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
![\"expoerted](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/6B6GEV3BMXO6\/expoerted-excel-file.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
