-
automation to update a date field to new value
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Android calendar view looks different than iOS
Since a few months ago, our Android users have been reporting an issue with viewing calendar events where events are shown as ellipses, as opposed to showing event detail. I've attached a screenshot of each view, showing the Calendar view of one of our Smartsheets. Any ideas?
-
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…