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.

Summary in Gant

Peter ✭✭
edited 12/09/19 in Archived 2016 Posts

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.






  • 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!

This discussion has been closed.