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
-
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:andree@workbold.com | 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?
-
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:andree@workbold.com | 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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!