I have a smartsheet with 4 columns: building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. 


However, cs manager always change.  We have 1000 buildings.  

Admin will send update list every week.. I know there is data live


I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks?


Thank you,

- Blake


I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.


Hi.  I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons.  I'd like the parent row to inherit the worst case summation of the child rows.  E.g. if the child rows are red, green, and green, the parent row would show