Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Smartsheet in Powerpoint - Not Gantt Timeline
I want to either export or copy and paste my Smartsheet into a Powerpoint table once a week. The text has to be editable after I paste it. When I copy and paste, it loses all formatting. The transfer process is going to be used by my director, and I can't ask him to do a lot of transformations or steps to reach the outcome.
I'd really like to keep our collaborative tracking in Smartsheet, but without this key feature, I'm likely going to have to put everyone back in PowerPoint.
Comments
-
Travis EmployeeHi Sarah! Getting grid data from a grid based program to Powerpoint will be difficult because they are two different formats (grid vs page with text boxes). If you want that data editable then it will be even more difficult. We do have a an integration with Office Timeline which can be used to easily add timelines and Gantt charts to your Powerpoint projects (see://m.santa-greenland.com/apps/officetimeline) but it sounds like you want to add grid data.
One option would be to have a link to a sheet in your Powerpoint. When you get to that slide, click the link to open the sheet where you can make your changes. This way, you won’t have to copy and paste any changes you make to the data in the Powerpoint back into Smartsheet and the data you are looking at will always be the most up to date information.
-
One suggestion would be to allow a static url to a row in a Smartsheet to be added to powerpoint as a hyperlink. This would allow you to summarize a list of activities or topics in powerpoint with the hyperlink to the Smartsheet row. This would would eliminate the need to cut&paste updates from powerpoint and allow direct updates to the Smartsheet row.
Right now the "Send Update" function only sends dynamic url's and are unreliable for my suggested use above. Let me know if there is a better way to obtain the SS Row url.
Categories
In your sheet, create a third section that adds the results of the first two. It would have the same rows, but the formula for each row would add the cells of section 1 + section 2.<\/p>
Add a helper column called ShowInReport as a Check Box and check all the rows in the third section. <\/p>
Create a report and tell it to show you only Section 3 (where the ShowInReport is true.<\/p>
I hope that makes sense.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":108888,"type":"question","name":"Is it possible to URL-Query an embedded form?","excerpt":"I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?","snippet":"I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?","categoryID":321,"dateInserted":"2023-08-13T01:16:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-13T11:02:58+00:00","insertUserID":161632,"insertUser":{"userID":161632,"name":"SteyJ","title":"Jacob Stey","url":"https:\/\/community.smartsheet.com\/profile\/SteyJ","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5Zjq-V_rc4o!zmkrczO71bo!6kwXWfi9FUH","dateLastActive":"2023-08-13T22:08:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-13T23:49:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3383814580,"url":"https:\/\/community.smartsheet.com\/discussion\/108888\/is-it-possible-to-url-query-an-embedded-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108888\/is-it-possible-to-url-query-an-embedded-form","format":"Rich","tagIDs":[204,254,292,530],"lastPost":{"discussionID":108888,"commentID":390381,"name":"Re: Is it possible to URL-Query an embedded form?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390381#Comment_390381","dateInserted":"2023-08-13T11:02:58+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-13T23:49:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-13T15:45:48+00:00","dateAnswered":"2023-08-13T11:02:58+00:00","acceptedAnswers":[{"commentID":390381,"body":"
