-
Assigning Team Memebers to Task/Duration
Let say you have a task with a set duration, start and end date. The duration was based on 1 person doing the work but if I want to assign it to 4 people so it theoretically goes 4 times faster. Is there a way to say to smartsheet "This task has 4 people working on it" and for smartsheet to then adjust the duration, start…
-
Helpful if Date format has letters in it
Hi, I am working on a project wherein a part of the development team in India and other part in the US. I initially had my Language (Country) setting as "English (India)", but this date format caused confusion for the team which are in the US, since it is based on dd/mm/yy whereas the US is used to mm/dd/yy. For example,…
-
Report showing different color than the row in the sheet
Hi - I have a report that I run that shows me all the line items from various sheets that are assigned to me. On the report is a column for "Sheet Name". When I run the report, all of the rows from one of my sheets looks the same - the value for Sheet Name shows with a white background and a blue link that I can click on…
-
Monthly Calendar View Exportable to a PDF?
Hi there, I have a large Smartsheet document that I would like to export to a PDF. While I can export it under the card view, regular view, and gantt chart view, I cannot export it with the monthly calendar view. Is it possible to export the monthly calendar view into a PDF or Excel sheet? Thank you!
-
Resourcing Allocations
I am trying to find a way to accurately reflect the resource capacity of an individual when assign multiple concurrent tasks in a single day. I appears that if I assign for example 8 one hour tasks (effort = 1h) that the person shows up at 800% capacity for that day rather than being at 100%. How can I make this work? Do I…
-
SubTotal
Is there some way to use subtotal with filters like in Excel ?
-
Ressource View on weekly or monthly basis
I like the resource views - really a very helpful feature. But the resources are shown on daily basis and what I need are figures on weekly or monthly basis (a kind of zoom). Is there any way to do this?
-
Error in creating new Smartsheet from Google Drive
Anyone see this or know how to get around this? I could not find anything related to this problem. I have successfully installed the Smartsheet app to Chrome from the Chrome Web Store. I do New->More->Smartsheet. I get past the "Your domain administrator has approved access to Smartsheet" . Then, I see the error message,…
-
"Modified By" Column not working after Publishing Sheet
The "Modified By" column turns blank after a user makes changes. When I view the cell history, it says "Publish User" made the change. Is there a way to tell who made the change to the sheet? My organization requires user login before making changes to the Smartsheet. Thanks!
-
SmartSheet charting
Is SmartSheet looking into making Excel type chart/graph creation available either within sheets or as an addon?