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


Morning All,

I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please?

I need the below:

If today > actual start date & today is > actual end date & % complete < 100% = Red

If today > actual start date &