Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there a way to automatically create an event on a Google Calendar based on data collected from a SmartSheet form?
Hi James,
Yes, there is!
Depending on the information you could add the date to Smartsheet and have that synced with a Google Calendar.
Another solution could be to use a third-party service like Zapier or similar.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Would any of those options work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi James—
Check out our Google Calendar integration: https://help.smartsheet.com/articles/518535-syncing-your-smartsheet-and-google-calendars
People can submit to your sheet through the form, then that info can sync with a Google calendar!
I have the following column set up as a primary key for a datamesh. The intention is to copy each row over to a reporting sheet 1 time each month. This formula has not changed, and the records within the "BCA #" have not changed - yet I see to inserts into my reporting sheet from a smartsheet automation with differing…
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…