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
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.

 

Thanks

Peter

Unbenannt.JPG

· Share on FacebookShare on Twitter

Comments

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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories