Sign in to join the conversation:
Hello,
What is the best way (if any) to do the attached view in Smartsheet? I would like to show status of projects during the month.
Thanks
Michal
Hi Michal,
You could use cell-linking or a report. It depends on your use case.
Unfortunately, it isn't possible inside Smartsheet to get different sections on one row if that's what you want.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Michal,
Andrée is correct. There is also no way to differentiation coloring of the Gantt chart if the data was on a single row.
I'm curious where the image comes from and the process rules around the coloring. In the past, I have seen something like
[Yellow]-[Green]-[Grey]
and
[Yellow]-[Grey]-[Red]-[Green]
but yours repeats colors, so it isn't based on phases (I assume)
Craig
Thanks Craig, this is a power point slide, the colors show the status of the project at the specific month.
Thanks Andree
Happy to help!
These articles might be helpful.
https://www.smartsheet.com/blog/office-timeline-and-smartsheet-3-steps-quickly-create-your-visual-project-plan
https://pincello-support.officetimeline.com/hc/en-us/articles/115015837627-Import-your-Smartsheet-data-into-Pincello
Andrée
Thank you!
You're welcome!
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
I have no idea how to start the program. I need the basics on how to build charts and graphs.
