-
Integrating non working holidays on another country
Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China. I think many of you have been affected by week long holidays like Chinese New Year week. Is there a way entering a certain countries holiday without making it…
-
from google to smartsheet
My team has been using Google Sheets as a colorful scheduling tool. They love it, and it has served them well for many years. I am not trying to reinvent the wheel. I am trying to stop utilizing Google since we live in Smartsheet. Any help to recreate this in Smartsheet would be beneficial. Cells are colored differently…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
Calendar View and Calendar Publishing from Dynamic View
Currently, Grid View is the only option for an external user to view data in the dynamic view. Please add a Calendar View option within the dynamic view, and please allow that calendar data to be published to a user's personal calendar if said user is allowed to export the data.
-
How can I update two sheets with the same information?
Hi, I have a sheet I use to update my teams webinar calendar. Another team in the business would also like to know when a webinar relevant to their team has been added to this sheet, so it replicates on their own training calendar. Is this possible? I was added as Admin to their calendar. I tried setting up an automation…
-
Share 'meetings' data (data, time, name of the meeting etc.) from a smartsheet into MS Teams
Is there a way to share 'meetings' data (data, time, name of the meeting etc.) from a smartsheet into a calendar app on MS Teams? Our client is maintaining a list of meetings in a smartsheet with all the meeting data in the form of columns. I want to be able to draw that data into an MS teams calendar app so I can use it…
-
How do I add a space in a reference formula? I want the space to display between the two values that
Good Afternoon, I have built an event calendar tracker. I want the display name on the calendar to include information from two columns of data. The formula I am using for calendar display is =Location1 + [Event Name]1. In the calendar display column I want a space between the location and event name.
-
Creating a workflow to trigger when dates in rows are reached
Good Afternoon, I'm wondering how to setup a workflow so that alerts are automatically sent to certain groups of individuals (which I have setup to be in separate columns) when the "Start" dates for a specific row occur. I have looked online but there only appears to be instructions for how to setup workflow for manually…
-
Can I submit multiple dates in a form for one event?
I am trying to build a social media content calendar. We have our posting schedule laid out at regular intervals prior to the event. For example, if an event takes place on March 17th then we would have a post going out on March 10th, a reminder going our the 16th, and another post the day of the event. I am using…
-
Individual dates integrated into Outlook
I have sheets with multiple date columns (start date, end date, and then some supervisor check-in dates in the middle of the date range), and I'd like my Outlook calendar to show these events as individual dates, rather than getting lost in the date range.
