-
In Calendar App/Quarter View, can you change the Fiscal Year output of year? (Q1-FY2022 vs Q1-FY2023
Our fiscal year runs April 1-March 31. In the Quarter View, all events running April 1, 2022 through June 30, 2022 are showing up as FY2023. However, April 1, 2022 is the START of fiscal year 2022 for us. I would like the Quarter View to show it as FY2022 Q1 and not FY2023. Is there any fix for this? (See below. Events in…
-
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
-
Reports - Publish as iCal
Is it possible to publish reports as iCal? If not, this would be a great feature.
-
How can I link two sheets together?
Hi. I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications,…
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
-
Calendar display summary tasks
I have Display Summary Tasks checked in calendar settings. Issue is that only some of the summary tasks are displayed (in Gray), but not all. How do I get all to display? They seem to be setup exactly the same.
-
New Taskbar Color for New Project
Hello All, I recently having been building up smartsheet for our agency and I had a questions about the taskbar colors. Right now I have a template that will be used for all new projects. The taskbar defaults to the light blue color. When coworkers use this template, I'd like the default color to be randomized so all…
-
Is there a way to share/publish a calendar view with only the calendar part minus the top and side..
Is there a way to share/publish a calendar view with only the calendar part minus the top and side tool bars.. I want to show only the parts within the red box. i dont want the viewers to change the calendar to grid or filter stuff..
-
Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
-
Extract Date from Modified Date
I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and…
