Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
