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 December 2016
Discussion List
Project with Multiple Dates and Hours
I'm working on a project that I completed over two days and want to document my hours for both days. Sometimes we work on projects over several days in different weeks. How can I enter all this data. Right now I only have one column for Date and Hours. Am I able to add more columns to enter more Dates and Hours?
Gantt Chart sum of days for subtasks
Hello everyone, We're using gantt charts to planify our tasks. When creating task groups and sub-tasks, the number of days displayed in the task group does not reflect the actual number of days planned but the time span from the beginning of the first task to the end of the last task. This creates confusion when presenting…
Automated RYG Balls
Hi everyone! I am trying to automate some RYG balls. Basically, i want to create a formula that says, if the number typed in one cell is between 0 and 5 make the ball in another cell go green. If the number is between 5-10, make the ball go yellow etc. Hope that makes sense. Thank you!!
Formula trouble with IF or IFS
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
=SUMIF across all children / grandchildren
Im not a power user but im looking to build out a bidding teplet for my shop. I have a lot of info spread across many children / grandchildren catagories. Heres what Im looking to accomplish. Itmes - Animals - - Cat - - - Brown 2 - - - Red 4 - - - White 1 - - Dog - - - Brown 4 - - - Red 2 - - - White 6 - - Fish - - - Brown…
Project Resource View
Hi Friends, In 'project resource view' currently I can see all members (project assigned members). But I don't want visulaize all members capacity at once. Is there any filter option? Reason: One month back my team member moved to other team & I am not assigning any task, yet I see him/her in the 'project resource view'.
