Premium Calendar App Not Syncing With Outlook
Hi I'm wondering if anyone has successfully gotten a Premium App calendar to sync or even display with Outlook calendar. Seems like it should be basic in that you publish the calendar for anyone to see and then use that link to subscribe within Outlook. I've not been able to get any data to show up after setting up the subscription. Any advice?
Answers
-
Genevieve P. Employee Admin
Hi@ccosta
There isn't a way to publish the Calendar应用程序display to an Outlook calendar, however you could go right to the underlying source data in Smartsheet (either the Sheet or Report) and publish that instead. See:Publish a Smartsheet Calendar to iCal
Cheers,
Genevieve
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/96595/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/96595/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>