-
Formula to calculate date
Hello, I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of the tasks automatically. For example, send agenda to attendees 2 months prior to the event. I've tried playing with the…
-
Calendar view
Hi anyone know why are the filters greyed out on calendar view when using the app ? New to this so wondered if i'm doing something wrong. Duncan
-
Date Range formula format
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of January? Is this possible?
-
Prefill Form with a Date Column
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would…
-
Can more than one person edit a calendar in Calendar App
Hi all, I have a team that's working with the Calendar App and we can't figure out how to have more than one person work on editing it. Is that possible? We don't need to transfer ownership, just have someone work on it... -Melissa
-
Publish calendar excluding summary tasks
I would like to publish my calendar as read only "for anyone with a link" without showing the summary tasks. I have this set up correctly on the calendar settings, but when I publish all of the summary tasks display. Is this possible? Thanks! Ilene
-
Date showing in Calendar Details
I know that a date column is required for the Calendar App to utilize your data, but is there a way to hide the date format from appearing in the details box? Our calendar is currently showing items that happen each day and only for an hour at a time, so nothing carries to a second date. Currently, every details box has…
-
Calendar view
Hi, I would like to set up something similar as shown in the screenshot below in Smartsheet. Dates for the rest of the summer to be shown in columns (vertically) and employee name in rows (horizontally). Once I have set this up on Smartsheets, would it be possible to switch to calendar view and in a nice format see which…
-
Calendar view question
Hi all, I believe since I had added a new comment in the attached calendar view post, it had dissapeared from the unanswered questions section of Smartsheet community. Can anyone please help? Thanks!
-
Google Calendar & Smartsheets Calendar Integration
Hello! I am trying to sync our smartsheets calendars with our google calendar. However when we publish it it brings in every task. Is there a way to just publish tasks that are assigned to specific people? There was a closed discussion about this on the boards from two years ago, hoping something has changed. Thanks!
