-
Possible to edit background colour in Calendar View?
Hi All. Here is my use case: we are using Smartsheet as our activity planning calendar for a team of dozen people. We have focus periods lasting from few weeks up to one month. We would like to communicate that e.g. May 1 to May 23 is time for Focus Area#1, and from May 24 to June 16 for Focus Area #2, and so on. Is there…
-
Calendar does not open in current month
Hello everyone, I have a Smartsheet calendar that has recently started to act a bit funny. It´s nothing major but it gets annoying. Basically, every time we open the calendar, it shows January 2017, which was when we created that sheet. While it is not a terrible error, it does take time to roll down to the current month,…
-
Define working days without affecting the calendar
My team travels for business frequently and we need to keep track of the weekends they have traveled on so everyone can get their days in lieu. I used the NETWORKINGDAYS formula and it looked fine. The problem is our weekends are Friday-Saturday instead of the regular Saturday-Sunday. If I enable dependencies to configure…
-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
Turnaround time for the month of...
I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…
-
Need Help with Calendar View Task Label Display
I am just learning Smartsheet and this is probably an issue with an obvious fix. I want to see my tasks displayed for my project in the calendar view. My tasks are listed in the primary column and they are visible in the gantt view. I can see the task when I double click on the task and takes me to the edit box. Any help…
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…
-
Calendar Legends or Headings
Is it possible to add a Heading or Legend to a Calendar?
