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

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.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 12/09/20

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!