-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
Problem with dates: day becames month and month becames day.
Hi. I am facing the following problem with date formats. In my source sheet, I have the following date: 04/12/20, which stands for 04/December/2020. An automation copies that value to another sheet, but in that sheet it appears as 12/04/20, which is 12/April/2020. I am doing anything wrong or is this a bug? If the day of…
-
Combined Calendar Report - Can I Automate Labels?
Hello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on my team can see a calendar of all their tasks for the week or month, with multiple…
-
Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
-
Formatting in Calendar App
When using bullet points in Calendar app, is there a way to break the line so that each bullet point would show in separate lines. At the moment, all content displays without line breaks in the Calendar App.
-
All Projects Overview/Scheduling
I am looking for suggestions and what other users utilize for an overview of all current projects within Smartsheet to prioritize and schedule. A summary report with a Gantt chart is just not sufficient enough to see how things are going within the business on all projects and the resources. We need to be agile and…
-
VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date. In a separate Smartsheet, we will be managing service tickets and certain types of requests…
-
Calendar App - Details view of multi-select fields
Hello! On Calendar App, I'm having an issue with multi-select fields not showing up on the details view when multiple items are selected. However, when only 1 of the multi-select options is chosen, it does appear on the details view. See screenshots attached. Any ideas? My workaround for now is to include the multi-select…
-
Calendar app filter
Hi there, I create a data sheet that connect to calendar app. I have a column with checkbox. is there a way that if I check the box in that column the data on that role will show in calendar app thanks, Jess
