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,…
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…
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…
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…
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…
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…
Is it possible to add a Heading or Legend to a Calendar?
New to smartsheets. How do I add in weekly meetings into a project (all on one line.) It is a long project and I don't want an entry for each meeting. Thanks in advance.
Is there a calendar view for the mobile app? We are only seeing a grid and list view.
Hello, Does anyone know if there is a way to set the default width of the 'days of the week' on the IOS calendar app? It would be huge if I could expand them. I can expand them when I open the app manually, but it would be great if I could have them open expanded. Thanks in advance, Dan