-
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.
-
Calendar View - Is it possible to format where the tasks are located?
Hello, We are attempting to move the entry on Calendar View to the middle rather than the top. Our goal is to separate the two entries - is this possible? Thank you!
-
Can the Calendar View display the sheet name instead of the primary column?
I'm creating a report that pulls in all of our Go-Live dates from all of our project plan sheets using a dynamic report in our control center. Is there a way to have the calendar view show the name of the project sheet instead of the primary column (in this case it's the task name in the project plan). So the way it…
-
Validation on Dates and or other data
Hello, We are trying to create a vehicle reservation form, we currently have 3 vehicles. Objective: A user submits a form to reserve one of the three vehicles. They select a date range. Click on all day or duration if it's half day. The administrator of the vehicles will then get the request and determine what's available.…
-
Is there a way to mass edit the color of an item in the calendar view of a sheet?
I'm creating a calendar with all the different tasks our leaders need to do each year. Is there a way for me to color coordinate so each task is the same color every month without going one by one? The screenshot below shows how you can do it for one item but that's too tedious. I've tried conditional formatting but that…
-
Calendar view
I've automated a vacation request form; and I see Calendar view in smartsheet, however it only shows the first day instead of all days when the employee is out of the office. Is there a way to show all days in the calendar view that the employee will be out? Thanks.
-
How do I change the field in Calendar View
I would like to change the field that is shown on the calendar view from the default unique identifier to the description field. I can't find anywhere in support for tips on how to do this. Just showing the unique identifier is worthless to me. Please help. Thank you.