-
Calendar View Report
Is there a way to show multiple date columns in Calendar View on a Report? I have multiple columns selected but only one is pulling through.
-
Smartsheet calendar in google calendar for non-smartsheet users; changes not reflected
I'm trying to find a way to add a smartsheet calendar to my team's google calendar where if I make changes to the event dates on the smartsheet calendar, they would also be reflected in google calendar. If my team subscribes to the smartsheet calendar via URL, they don't see changes made after they've subscribed to it. My…
-
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…
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
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…
