Synchronization of Smart sheet and Outlook Calendar

Kenji
Kenji ✭✭
inSmartsheet Basics

I am trying to synchronize an appointment list created with Smart sheet with Outlook Calendar. I

was able to get the date to reflect in Outlook Calendar, but is there any way to get the time and the content of the appointments on the Smart sheet to reflect in Outlook Calendar?



02.png


03.png


· Share on Facebook Share on Twitter

Best Answers

Answers

Categories

I got it. Change the Starting number to the number you want for a new row. Hope this works.<\/p>
\n
\n \n \"Screenshot_20230803-201230.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":108418,"type":"question","name":"Row Report from Sheets in Workspace","excerpt":"If I have a set of folders under a workspace with different type sheets. Some will be Project plans, others may be RAID\/CRAID Logs, etc. Is there a way to create a row report of all the RAID\/CRAID Logs only, and separate from a similar row report with all the Project Plan line items?","snippet":"If I have a set of folders under a workspace with different type sheets. Some will be Project plans, others may be RAID\/CRAID Logs, etc. Is there a way to create a row report of…","categoryID":321,"dateInserted":"2023-08-02T14:40:11+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T16:17:51+00:00","insertUserID":159779,"insertUser":{"userID":159779,"name":"BStump","title":"","url":"https:\/\/community.smartsheet.com\/profile\/BStump","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cujqB1-W9go!xFsrMbvl6Mo!D9rNxJuoFT5","dateLastActive":"2023-08-02T21:15:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":126800,"lastUser":{"userID":126800,"name":"Kelly P.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T16:17:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":40,"score":null,"hot":3381983282,"url":"https:\/\/community.smartsheet.com\/discussion\/108418\/row-report-from-sheets-in-workspace","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108418\/row-report-from-sheets-in-workspace","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":108418,"commentID":388532,"name":"Re: Row Report from Sheets in Workspace","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388532#Comment_388532","dateInserted":"2023-08-02T16:17:51+00:00","insertUserID":126800,"insertUser":{"userID":126800,"name":"Kelly P.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T16:17:14+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-02T16:16:11+00:00","dateAnswered":"2023-08-02T16:04:24+00:00","acceptedAnswers":[{"commentID":388524,"body":"

@BStump<\/a> <\/p>

This method does produce separate reports:<\/p>

The Project Plan report will include this filter: \"Sheet Type\" is one of \"Project Plan\" -- this filter will exclude rows coming from the RAID Log (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"Project Plan.\" <\/p>

The RAID Log report will include this filter: \"Sheet Type\" is one of \"RAID Log\" -- this filter will exclude rows coming from the Project Plan (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"RAID Log.\" <\/p>

Thus, each report will include a filter rule specifying that only rows with its own sheet type can be included.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":108417,"type":"question","name":"How do i set up a conditional format, when i want more than one person in the assigned to column","excerpt":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?","snippet":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that…","categoryID":321,"dateInserted":"2023-08-02T14:26:40+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159629,"lastUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3381977656,"url":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","format":"Rich","tagIDs":[245,254,334,437],"lastPost":{"discussionID":108417,"commentID":388509,"name":"Re: How do i set up a conditional format, when i want more than one person in the assigned to column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388509#Comment_388509","dateInserted":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9VLKF1G9AO1Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T09:17:11+00:00","dateAnswered":"2023-08-02T14:42:44+00:00","acceptedAnswers":[{"commentID":388483,"body":"

@Genesia<\/a> <\/p>

I would use conditional formatting. The rules for individual people should be in the form \"If Assigned To is equal to 'Curtis Coleman' then apply this format to the entire row.\" It's important to use \"is equal to\" rather than \"contains.\" Then add a final rule (at the bottom of the list of rules): \"If Assigned To is not blank then apply this format to the entire row.\"<\/p>

With this structure and wording for the rules, rows with a single person assigned will get their individual color and those with two or more people will get the color you assign in the last rule.<\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4909,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Auto number column giving duplicated numbers

    Hi All, I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula. Does anyone know why it is giving duplicate numbers? Thanks.

  • Row Report from Sheets in Workspace

    If I have a set of folders under a workspace with different type sheets. Some will be Project plans, others may be RAID/CRAID Logs, etc. Is there a way to create a row report of all the RAID/CRAID Logs only, and separate from a similar row report with all the Project Plan line items?

  • How do i set up a conditional format, when i want more than one person in the assigned to column

    I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video