Summary in Gant

Peter

Hi there,

 

is it possible to get a summary row in the gant like this:

 

 

I need to know the sum of the lines for the week.

 

Thanks

Peter

Kate French

Hi Peter, it sounds like you're wanting to get a total of the values in a column based on whether or not a row's date falls within the current week. 

 

There's not a way to do this directly within the Gantt chart, but you could get something like this achieved using a SUMIF formula. For information on building formulas in your sheet, check out the article here: help.smartsheet.com/customer/portal/articles/775363. 

 

Let me know if you have any questions and I'll be happy to help!