Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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!