- Calendar calculation (possible bug)
I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…
- View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
- Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
- Sync Smartsheet calendar to Outlook - help troubleshooting issue please
Hi everyone, thanks to the useful posts here, I was able to sync the Smartsheet Calendar to Outlook, but no events show up in Outlook. I am pretty new to Smartsheet, so not sure what information you might need to help me troubleshoot. Can anyone help please? Thanks, Patrick Here are two screenshots, showing Smartsheet and…
- Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
- modify titles in calendar view
I really like the Card view and how you can show different fields or parents of things in the description. I would very much like this to be added to the calendar view. Defaulting to the primary column is very frustrating IMO and makes the calendar functionality almost useless for project management IMHO.
- Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
- More robust calendar
Will there ever a be a proper calendar in Smartsheet? For example, an actual calendar and not just a spreadsheet with a calendar view that shows only one line (the primary column name). Would be nice to display times on the calendar and more fields, not just the primary column name.
- Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
- Calendar View Month has 6 weeks?
April 2017 is an aberration. It spreads across 6 calendar weeks. So is July, so maybe not so rare. Is there a way to show the entire month in Calendar View? (I doubt it) Craig
