Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for February 2016
Discussion List
Sanity check needed
For the PM's out there Duration: 1 hour Pred: 23FS - 1h Duration: 1 hour Pred: 23FF should both start and end at the same time (that is start 1 hour before 23 ends and finishes when 23 ends) I'm not missing something there, am I? While the first is allowed, perhaps it should not be as that invalidates the "predecessor must…
How to sum durations of time?
I have multiple columns that are formatted as durations in hours. I need a formula that can add these together, and show the results in hours too. In Excel, you can specify the formatting using [h] but it's looking like Smartsheet can only add numbers and dates, not durations of time. Any advice greatly appreciated!
Checkbox
Can I make a checkbox row instead of column?
Best/Good Practice request: Resource Leveling
Another better practice looking for. How do you handle completed tasks and resource leveling? If there is a 8 hour task scheduled for this week and the person knocks if off on Tuesday, they aren't needed on Wed-Fri at 20%. For long term planning, I'd really like to know the task took 8 hours and that the person did it in…
Best/Good Practice request: True up miscellaneous tasks
Looking for better practices than what I am currently doing. Example: On Tuesday, I expect to get something from the vendor. Usually that means end of day for planning purposes. I put that in the schedule as either a milestone (0 duration) or a full day task. On Wednesday, Admin Albert needs to spend less than 2 hours on…
Live/Real time Excel docs?
Once you insert Excel doc, how do I make it a live doc so all contributors can make real time changes and have it saved that way?
Excluding indented rows from being auto-numbered
I am using a web form for users to intitate developent requests and have set up column to auto-number each job request (P0001, P0002 etc.). The shop supervisor then adds rows below each job request to assign tasks to different team members and indents these under the main job request. Smartsheet assigns each indented row…
How can I exclude a task(s) from my report if the predecessor for that task is not complete?
I have a dozen or so proejcts each with their own sheet. I've created a simple report that looks at each project and returns tasks that meet two criteria: 1. The task has not been marked complete 2. The task has a due date of 5 days or less. This report works fine, but it returns more data than I want to report on.…
Entire Row Reference in Formula
Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column. Thank you!
error adding licensed user
We are getting an error message when trying to add a licensed user. Says that email is already associated with another account. He is a new university employee with a new email. He never used Smartsheets before. Tried adding him from my sysadmin account and my manager, the owner of the account gets the same message. We…