Is it possible to add all values that occur within the same date range

Danny Shoffman

See image for what I'm trying to achieve. Essentially I'd like to know if it's possible to either display values in Gantt view or if its possible if I have a value in a column (Est Hours per Phase) if I'm able to sum the total hours that occur in a given week so I understand the total effort required for that week. See the second week in February in this example where you have multiple projects occurring at the same time and the total of all the hours in that week is 80.

Andrée Starå

Hi @Danny Shoffman

Yes, something similar could be structured in Smartsheet, but it won’t look the same because we don’t have merging cell features. It will probably take more space or need to be structured differently but still show the same information.

In the Gantt bars you can only show one cells value, but it can be set up to include values from multiple columns.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Danny Shoffman

Hi @Andrée Starå ! Really appreciate your reply.

I have seen the option to display a cell value but did not know you could include values from multiple columns. Can you elaborate on how this is done?

Andrée Starå

@Danny Shoffman

You're more than welcome!

It would look something like this.

=C@row + " - " + D@row + " - " + E@row

Or this. =JOIN(C@row:E@row, CHAR(10))

This would show it like.

Column C

Column D

Column E

Make sense?

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!