We want to create a Smartsheet that is automatically populated with Subject, Location, Date, Time, Duration when we invite an alias to a meeting. Is anyone aware of a way to do this?
我们所有的项目我们会这样做/program meetings to help us provide corporate visibility to the meetings and attempt to avoid scheduling conflicts.
From this Smartsheet we could add additional information like meeting notes and action items and build reports that are then individual project/program calendars for folks to be able to view only events they are interested in.
✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking 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!
I was thinking it would most likely need a 3rd party like Zapier or Microsoft Power Automate. (For a production level solution Power Automate would probably be the route I would need to go as it's already through our IT approved applications.) If you've got Zapier ideas, I'm all ears!
@Andrée StaråI am looking to do a form for people to register if they want to attend a training. I have created a meeting in outlook and would like to paste the invite link into a cell as the default when someone submits the form. I then have an automation to send an alert to the contact cell with the meeting invite field for them to click and save it to their outlook calendar. The problem is, how do I get the iCalendar link to put in the meeting invite field in smartsheet?
I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.
I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.<\/p>","bodyRaw":"[{\"insert\":\"I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.\\n\"}]","format":"rich","dateInserted":"2023-04-25T15:05:54+00:00","insertUser":{"userID":150223,"name":"Heather_Verde","url":"https:\/\/community.smartsheet.com\/profile\/Heather_Verde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T21:04:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373182#Comment_373182","embedType":"quote"}">
https://community.smartsheet.com/discussion/comment/373182#Comment_373182
@Heather_VerdeI'd be interested in seeing how you set up your event registration sheet + your event data sheet. Could you share a screenshot without any records so we can see your columns and such? Or perhaps a Miro/Mural screenshot of the flow? This is something high on our interest as well.
Andrée Starå ✭✭✭✭✭✭
Lori Hight ✭✭✭✭
