-
Can calendar view default to current month when a sheet is opened?
It seems there'd be a way to do this but I haven't figured it out if there is. I have a calendar that displays important dates from linked cells in another sheet. I set it to default to the calendar view but every time it opens it displays June 2017 even though it's currently April 2018! I'm guessing it's drawing from the…
-
Need for darker lines and dates on printed calendars
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Cell Time Stamp
Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to when we will need to ship samples.
-
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…
