-
Auto Populate an entire column with the value of one cell from another column
I'm trying to populate an entire column with a value from one cell from another column within the same sheet. Is there a way to automate this process. I would like the value that the arrow is pointing to populate the entire column "Project Name". I'm using the column as a helper column in the calendar app as a way to group…
-
How do I calculate the difference between 2 dates?
Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no?
-
Calendar Display Column
How can I change which column is displayed on my calendar?
-
Connecting Smartsheet to existing Outlook Calendar
Hello- Our team uses an existing O365 Outlook calendar to track events. We'd like to tie in a smartsheet to that existing calendar, but the only way that it seems possible is to create a separate calendar just for Smartsheet. Is there a solution where I can add smartsheet events (start/end date) automatically to this…
-
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.
