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 2015 Posts
Archives for July 2015
Discussion List
Gant Chart Timeline in minutes/hours
Can i show my giant chart in minutes/hours rather than days?
planned versus actual
Is there a way to track what hours are actually spent on a task in relation to the hours that were planned?
Is there a way to set a default sort order on a sheet?
I have an open issues list. I would like it sorted by open/closed, then by priority. I can do this manually each time, but I would like that as the default anytime someone access the sheet. Is this possible? Thanks. Wayne
Linking discussions and attachments
I do not see a way to link discussions and attachments to another sheet. It would be great if not only the task and other columns are linked but have the discussion(s) linked also. Does anyone know if we can or another way to accomplish this?
Sharing
Can I share a sheet within a workspace without sharing all the other sheets in the workspace? If so, how?
Formula help - if cell is blank, checkmark cannot be checked
Brain cells are missing. I've looked through the formula examples and can't seem to put together the formula I need. We have a column that needs to have text in it before the Checkmark column should be marked with a check. Here's the scenario: IF column B is empty, checkbox cannot be checked. This will help our team…
COUNTIF with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks…
Is there a planned development / release date for % of resource to impact scheduling?
I.e. an effort based as opposed to duration based scheduling? At this point, I feel like I am doing all the scheduling work, and Smartsheet is only providing some reporting features. Standard PM methods would be assigning a resource to a project on a percentage basis (common in real world) and let the tool determine…
Resource Placeholders?
New (or "re"new) to SmartSheet (not project management) and I am trying to do something that would be easy in MSProject, but for which I am hitting roadblocks accomplishing in SmartSheets. When planning out projects, we would normally use resource placeholders, until actual resources are assigned, i.e. Engineering,…
Copy conditional formatting over multiple sheets
Hello, I was wondering if there is a way to copy the conditional formatting roles to multiple sheets. Thanks,