Without a doubt this was the best Smartsheet video I've ever watched!! I'm progressing through the learning process, and I need more of these tutorials to bring it to life. The brief videos they produce are great for introduction, but not much beyond that. I will search to see if you have more. Thanks!
Thank you so much Eddie, great to hear it. If you are interested, I have also just released my full dashboard training course: properprojectmanagementtraining.teachable.com/p/smartsheet-dashboard-training-course
Thanks Emka. Good question; not too sure on this one. I don't think my organization has but that doesn't mean its not possible. Perhaps send Smartsheet support an email - that will let you know for sure.
Thank you so much! this is great. I've been using 'reports' to summerise data from my original sheet for dashboards. Is there any advantage to setting up a seperate calculation sheet?
Hi, is there anyway to create filters in the dashboard? Using your example what i mean is, is there a way to get a view on the dashboard of let's say how many pencils you got in the month of january? Do you have any idea on how can i pull that one? Awesome video though, helped me a lot!!
Your videos are so helpful. I have a question, I created a dashboard for the projects and want all my team members to update the project status weekly. How do I ask them to update the weekly status in dashboard without going to multiple sheets.
Hello Suchitra; thanks for your kind words. It depends how you set it all up. But a report could work here that pulls the multiple sheets together. Or you could use a widget that allows them to update the dashboard manually and centrally.
@@ProperProjectManagement You are very welcome. Have you done a presentation about approval workflows on Smartsheet forms such as when to form is completed, and starts a workflow?
If I understand correctly this could be done via a report which then feeds the dashboard. But in order to filter further you'd need to edit the underlying report.
You offered to help if someone needed it at the end of this video. I have a project that I'm having trouble working through building a dashboard. How do I get in touch with you?
Question - can you use a built timeline sheet to create a report or does it need to come from the template sets? It may be a permissions issues, but I can't seem to pull my project plan in. Thanks.
Hello. It's hard to tell without knowing the specifics but it does sound like you should be able to. Is the dashboard in the same workspace as the timeline sheet/report?
Hi, I want to create project timeline gantt chart for various projects, is there any way I can upload my sheet and it will update the dashboard, as we do in PowerBi update data through sharepoint.
If I understand correctly and assuming your data sheet has the necessary columns/data you should be able to view a can't chart his the grid/sheet view and could display that on the dashboard
Hello Eric. You would need to create the data entry form first and foremost, obtain the link and then add this to the dashboard (or search for the form).
when you went into set up Dashboard Tutorial under sheets--there was Dashboard Tutorial folder that provided the sheets needed to begin creating a dashboard. I did not see that in the options for templates to download.
@@ProperProjectManagement I figured it out. I listened to the beginning of the tutorial and you had mentioned it. I must have missed it the first time around. Thanks for assisting!!
🚀 Finally create impactful, insightful Smartsheet Dashboards with my (discounted) course 👉 properprojectmanagementtraining.teachable.com/p/smartsheet-dashboard-training-course
I was so stuck and this helped alot! I had no idea we needed calc sheet to populate dashboard. Thanks so much!
You're very welcome Aisha! Thanks a lot for dropping a comment :)
Without a doubt this was the best Smartsheet video I've ever watched!! I'm progressing through the learning process, and I need more of these tutorials to bring it to life. The brief videos they produce are great for introduction, but not much beyond that. I will search to see if you have more. Thanks!
Thank you so much Eddie, great to hear it.
If you are interested, I have also just released my full dashboard training course: properprojectmanagementtraining.teachable.com/p/smartsheet-dashboard-training-course
SUPER SUPER HELPFUL!!!! Thank you. This is EXACTLY what I needed and looking for. Call yourself my SS guru and trainer from now on.
Fantastic! So pleased to hear it was so useful!
You dont have any idea how this video helped me on my work. THank you so much!
That's amazing to hear, thanks for letting me know :)
This was BEYOND helpful! So simplified and gave me a great jumping off point to further develop my skills with smartsheets!
Hello Sue. So pleased to hear that and thanks for dropping a kind comment. All the best with Smartsheet!
I just got started with SS, this is definitely going to make me look good at work.. Thank you, super helpful. Subscribed!
Thank you for the kind words Donovan. Hopefully it helps in your role. All the best with Smartsheet!
Just brilliant!! Thanks so much! Simple, straightforward and got me going in the right direction.
Great to hear! Thanks so much Mindy.
This has been my to to video as I continue to develop a dashboard for my team. Thanks
Great to hear it, thanks Matthew
This was useful and you clearly showed proper way to create a dashboard
Great to heat it :)
Very helpful for putting together a basic dashboard. Will definitely use some of this information in the future to build my own!
Thanks so much Ryan. Appreciate the kind words. Take care and all the best for your future dashboards :)
This tutorial is so helpful! The pacing is perfect.
I'm so glad! Thanks Jill!
Thank you for showing the remedy when things don't go as planned. Great vid.
Pleased this video helped you, thanks for dropping a comment and letting me know.
very well done! I learned a lot in only 35 minutes..thank you!
Pleased to here it. Thanks for the kind words. All the best
This was exactly the help I was looking for and you moved at a great speed that allowed me to easily follow along. Thanks!
Thanks so much for the kind words Cicely. So pleased to hear it was useful for you.
Thank you so much! I followed along and created my first dashboard. I did not have any info to add a report though.
Very pleased to hear this. Congrats and well done! Thanks for dropping a comment.
Sharing knowledge is great in life. This training is awesome.
Thanks you very much for your time and effort.
My pleasure! Such a nice comment to read, thank you.
This was perfect. Easy to understand.
Thanks Ralph; glad it was useful for you
Excellent information and tutorial, thanks and congrats for making things so clear!
You're very welcome!
Extremely helpful video! Thank you!!!
😊
Thank you, pleased to hear it :)
Hello this was very helpful- my biggest issue was organizing the data to create the dashboard.
Thanks Javerea. That's right; data organization is the most important thing.
Hi there! Wondering if you might be able to help with a calculation on my dashboard! Love your videos!
Hello Jen. Sure, I can try to help; send me an email explaining the issue and I'll see what I can do!
Thanks for the great video! Do you have any hacks on how to add a link to a local network file on a dashboard?
This was awesome. Thank you so much.
Thanks, Charmaine. Pleased to hear it was useful :)
Hi, great tutorial. Do you happen to know if we can connect our power bi dashboards and displays it in Smartsheet Workspace or WorkApps?
Thanks Emka. Good question; not too sure on this one. I don't think my organization has but that doesn't mean its not possible. Perhaps send Smartsheet support an email - that will let you know for sure.
Thank you so much! this is great. I've been using 'reports' to summerise data from my original sheet for dashboards. Is there any advantage to setting up a seperate calculation sheet?
Great to hear it Sarah! It just keeps it organized and in my opinion easier to update. Less messy, for sure.
Excellent video - thanks!
Glad you liked it Sounil!
Hi, is there anyway to create filters in the dashboard? Using your example what i mean is, is there a way to get a view on the dashboard of let's say how many pencils you got in the month of january? Do you have any idea on how can i pull that one?
Awesome video though, helped me a lot!!
Your videos are so helpful. I have a question, I created a dashboard for the projects and want all my team members to update the project status weekly. How do I ask them to update the weekly status in dashboard without going to multiple sheets.
Hello Suchitra; thanks for your kind words. It depends how you set it all up. But a report could work here that pulls the multiple sheets together. Or you could use a widget that allows them to update the dashboard manually and centrally.
Thank you so very much for the wonderful presentation.
You're Welcome Mark. Thanks for leaving a comment, glad to hear it helped you :)
@@ProperProjectManagement You are very welcome. Have you done a presentation about approval workflows on Smartsheet forms such as when to form is completed, and starts a workflow?
Excellent tutorial
Glad you think so!
Excellent video! Doubt Is it possible to filter by dates what is presented in the dashboard?
If I understand correctly this could be done via a report which then feeds the dashboard. But in order to filter further you'd need to edit the underlying report.
Great job!
Thanks
You offered to help if someone needed it at the end of this video. I have a project that I'm having trouble working through building a dashboard. How do I get in touch with you?
Hi Thomas. I replied to one of your previous comments - please email me at: theproperprojectmanagement@gmail.com
Can you make this kind of video but for Excell ? Thank you in advance.
Very helpful!!
Pleased to hear it was. Thanks for letting me know via a comment Michelle.
Thank you!
You're very welcome
Do you have a copy of the sample data you use in your Data sheet? Want to follow along with the tutorial but difficult to do without that data set!
I don't readily available, unfortunately, sorry. There are tools you can find via google for "dummy data" you may be able to leverage...
Oi I'm absolutely knackered
Hopefully in a good way!
Question - can you use a built timeline sheet to create a report or does it need to come from the template sets? It may be a permissions issues, but I can't seem to pull my project plan in. Thanks.
Hello. It's hard to tell without knowing the specifics but it does sound like you should be able to. Is the dashboard in the same workspace as the timeline sheet/report?
Very helpful!!
Glad you think so!
How to add filter in the dasboard?
very helpful. thanks
You're welcome!
Hi, I want to create project timeline gantt chart for various projects, is there any way I can upload my sheet and it will update the dashboard, as we do in PowerBi update data through sharepoint.
If I understand correctly and assuming your data sheet has the necessary columns/data you should be able to view a can't chart his the grid/sheet view and could display that on the dashboard
Hello, I am Felix.
How do I build a tracking and report system in smartsheet?
Have you considered my course: properprojectmanagementtraining.teachable.com/p/smartsheet-dashboard-training-course
How do you put a link to a data entry form on the dashboard?
Hello Eric. You would need to create the data entry form first and foremost, obtain the link and then add this to the dashboard (or search for the form).
when you went into set up Dashboard Tutorial under sheets--there was Dashboard Tutorial folder that provided the sheets needed to begin creating a dashboard. I did not see that in the options for templates to download.
Hi Bianca. I set these up ahead of recording. Where were you looking for these specifically?
@@ProperProjectManagement I figured it out. I listened to the beginning of the tutorial and you had mentioned it. I must have missed it the first time around. Thanks for assisting!!
What if I have multiple items in one collum and i want to make the same calculation?
Can you please elaborate Patrick
Do you offer 1-1 training?
Hi Fiorella. I do, please contact via email. Thanks
Dumb question 🤦🏾♂️ can you do multiple projects in one sheet?
Hello. Not a dumb question; you can depending on how the data is organized!
Like, gentleman.