- Using time formula to create a master schedule
I am trying to create a sheet with a formula that calculates total time worked in a day, from a start time to an end time. I want to show who is working in specific units, from 8:30am to 7pm, at 30 minute increments for a 18 week period. See my pdf mock up attached. I created it in Excel. Any help would be a big help!…
- Report Error
你好,我想创建一个报告hat brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to…
- Calendar view - more than two dates / no start-finish date?
A bit of a strange question here. I'm working with a team that deals with e-news. Smartsheet is used to record the individual news pieces, who the recipient is, and the date that it is being sent out. Each news story goes out on three seperate dates (current week's Tuesday, current week's Thursday, next week's Tuesday).…
- Publish Calendar Format - Hyperlinks Lost
Hello, I searched but didn't see an answer to this issue: I maintain a calendar, based off a SmartSheet template, whichI publish to our intranet. In the description field, I would like to include hyperlinks. In grid view, the hyperlinks are active and functional. When I change to calendar view, both for myself or looking…
- Change parent row from import
We are looking at switching from google sheets to smartsheet and cannot seem to find a way to change the parent row in smartsheets. We have selected every option that we can find, but just not the right one. Note: We want the parent row to be our task name, so that it shows up in the calendar view. Currently it's a number,…
- Calendar
Our tradeshows are listed by week i.e. Week 1: 5/1-5/5 in the Grid view. When I switch to Calendar view, the trade show isn't listed at all? Any sugestions on how I can see all of our tradeshows in a given month? Thanks.
- Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…
- Recurring dates on a calendar
I am converting some calendars from Sharepoint into Smartsheet, and can't figure out if or how I can make events recurring. For example, I'm building an on-call schedule and the schedules are regular. Every so many weeks, each person takes a turn. Has anyone been able to accomplish this? I don't want to have to enter each…
- Detailed timing?
Hi Folks. I see that there have been discussions for years about a feature that still seems to be missing. Even if now the duration of an event can be determined pretty detailed, we still can't tell that it is supposed to start at i.E. "9:15am next Tuesday"! Did I miss something, or is this feature really not yet…
- Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
