2 ай бұрын
4 ай бұрын
5 ай бұрын
Пікірлер
@Masfugo 2 күн бұрын
Oh god thanks. I deleted a task thinking it was a duplicate
@Waterbottle365 5 күн бұрын
Is there no way to add tasks to someone's Outlook calendar? It looks like Microsoft wants you to manage everything through To Do..
@SkullFoundry 9 күн бұрын
Still doesnt work on mac
@marisolwhalen9872 16 күн бұрын
This is AMAZING! Thank you for keeping it simple. First time Power BI user long time Smartsheet user and this will change my team's lives!
@echolocity 11 күн бұрын
So glad it was helpful! PowerBI is a super powerful tool - I love the dynamic filters and we find it helps leadership get even better visibility across initiatives.
@KellyWiesehan 17 күн бұрын
This was SO helpful! Thanks for making these videos!
@echolocity 17 күн бұрын
Excited to add more! Heading to DareTable later this month to talk product Roadmap, AI and expanding our AirTable services to help awesome teams and builders do even more with @airtable
@deusx.machinaanime.3072 19 күн бұрын
Originally, it should be Dependency rather than Decisions, right? Because Actions has the Decisions already
@echolocity 11 күн бұрын
We've seen it many ways. We replaced our decision logs and meeting minutes with CRAID logs. With Programs and Portfolios, we often use dependencies (and assumptions for the A as well). We've helped clients expand the concept to include Questions and Support Requests too : CRAIDSQ - but we just call them CRAID logs. The core concept is a single consolidated log - with the goal of making meetings more actionable and improve accountability.
@deusx.machinaanime.3072 10 күн бұрын
@@echolocity Yes, I have seen CRAID too. The major problem of just using Excel for this purpose are how to display their inter-relationships to one another in a Project, and worst still, how they inter-relate within a Program Although registered and logged, linking a decision to an action, then with a risk and then a dependency (or more) becomes taxing. Hence, the use of a special database or app to fill in this tool feature gap.
@julianabaum8994 24 күн бұрын
Is it possible to link the intake sheet with the individual project sheet just with the business license?
@echolocity 22 күн бұрын
Yes - we have a work around for this where we use look-up formulas. In Smartsheet you can use Cell Links, Look Up formulas that reference other sheets, and you can use sheet and dashboard URLs to make navigation more automated.
@brandonwilliams9085 Ай бұрын
But you already have the column !!
@echolocity Ай бұрын
To get predecessors enabled, you need to go to the Gantt view -> Gear, and that can be confusing. If a column already exists you can select it from the settings. Did we miss something?
@AkshayPrasath11 Ай бұрын
Is the connection live? Would any changes to smartsheet reflect in the dashboard when I refresh the data?
@echolocity Ай бұрын
Yes, it is live. If you see a discrepancy here are a few troubleshooting ideas : Save the report or sheet you were updating. Refresh the dashboard via browser. If you are still seeing a missing change - consider if there may be automations that may have delayed triggers to update data from another location?
@KeithSavage-v1k Ай бұрын
Careful this same thing happened to me. When I trigger this and click run it moves literally everything in the sheet not based off of anything it seems. Looking into why this is happening.
@echolocity Ай бұрын
Thank you for the warning! We haven't seen a notice from Smartsheet of the error. Did you reach out to Smartsheet if there was a known defect?
@TheBioHackerBoss Ай бұрын
OMG thank you. I've bees watching so many videos on how to do this and your's finally did it for me. (For some reason I originally skipped over your video in the search results, I think it's because of the thumbnail, I didn't think it would solve my issue. Might want to update it.)
@echolocity Ай бұрын
Great feedback! Yes, we need to update our thumbnails! So glad it helped!
@MrOliverBob Ай бұрын
Great video, thanks for sharing. What software are you using for the screen/video recording? Thanks in advance.
@echolocity Ай бұрын
We usually use Loom for our KZbin Videos and any educational videos for our clients, but we also sometimes use Teams or edit in Microsoft's ClipChamp depending on security policies etc.
@xvfifavx Ай бұрын
Hi. Thanks for this. One of the issues we are encountering is the max of connected boards for if we have lots of projects. Do you know of any way around this ?
@echolocity Ай бұрын
This depends on licensing tier I believe - so if you are at a lower tier you can upgrade and get more boards. If you are already on an Enterprise plan, there are options - we have used PowerBI for Enterprise dashboards. You may also want to look at your solution architecture efficiency on why you need more than 200 boards....
@RebeccaLeu-t3u Ай бұрын
Helpful video! You mention this is part 1 in a series, what is the rest of the series? Thanks!
@echolocity Ай бұрын
Coming soon! This fell off our list - but I will make sure it moves back up! Thanks for the reminder! Glad you found it helpful!
@rachelmiddleton4690 Ай бұрын
How can we display timeline view in dashboard reports?
@echolocity Ай бұрын
It does not appear to be working currently. When we first tried, we went to the sheet, set the default view to timeline, then published the sheet and grabbed the embed code. However when I test now, it is defaulting to the grid view if I have selected timeline. I don't see the option in reports. I assume it will be rolling out shortly. Engage is next month, so my best guess is that we will get exciting features in timeline and board views since it will be easy for their execs to talk about and show off.
@jefffairchild1854 2 ай бұрын
This was made in 1995 in 144p
@echolocity Ай бұрын
:) not quite, but the feedback is legit regardless of the accuracy of the timing!
@KeithCole 2 ай бұрын
Really, really helpful. I’ve been looking for someone to explain how to use and integrate Loop. I’d love to see more on that.
@echolocity Ай бұрын
YAY! So glad it was helpful! We will be releasing more and more Microsoft videos on Planner and Loop as they mature their program management and portfolio management capabilities.
@paulbarrett9300 2 ай бұрын
Can you select multiple sheets, and multiple reports?
@echolocity Ай бұрын
Yes, however we often times will use a Smartsheet report with multiple sheets in it since our consultants find it easier and more intuitive to adjust data sources on the Smartsheet side then have to add new sheets into PowerBI on a regular basis.
@jimgui-j5n 2 ай бұрын
Very Nice knowlege sharing. I do find the table in dataverse for the project but I don't find the "custmized colume" data, anyone happen to know where can I find those custmized colume data so I can use it in PowerBI dashboard.
@echolocity Ай бұрын
Great call out! We literally were talking with Microsoft about this on their AMA call earlier this week. Basic is not in Dataverse and we are hoping for easier access for custom. In the meantime we've been using buckets and tags to get the reporting we need - but agreed custom columns in dataverse are needed!
@alpineai 2 ай бұрын
Can you do rhis in Airtable
@echolocity 2 ай бұрын
Hi Shola - you could create a base for a project that serves as a template, then duplicate that for each project. That is different than assigning one or more task lists to a project, though. This is much more flexible in Teamwork.
@TheDataMaestro 2 ай бұрын
Sorry if I sound gruff, but your section on resource planning offered nothing. First, you should have acknowledged that Smartsheet does not offer resource leveling. Then, you went on to say that you didn't know of any tool to address that issue. Was your conclusion that every few weeks an organization needs to redo their resource planning? I'm confused.
@sararc84k42 Ай бұрын
this is what PMO’s do. you asking is really revealing. I worked in a large PMO group and we had to check resources weekly if not DAILY. I can see why you would be confused.
@echolocity Ай бұрын
We would love Smartsheet to have more resourcing capabilities like leveling and additional baseline functionality, but we have found work arounds and options that do not require full rewrites every few weeks :) At Echo we talk a lot about capacity planning and resource management organizational maturity For example : Crawl : Project Team Identified, Roles/ Responsibilities, High-level effort estimates by team / role Walk : Approval of ‘Named’ Resources, Forecasted Effort for Approved Projects, Actual Time Tracking Run : Individual Resources and Effort estimates assigned at task level, Forecasted effort for projects prior to approval, Governance / Prioritization methodology established Major issue for most PMOs and yes, lots of tools handle it in different ways (or don't handle it), but solutions for resource management and capacity planning require a combination of people/judgement, process/methodology and technologies.
@hildagarcia4555 2 ай бұрын
Curious how you get multiple dates to show in card view? Are those assigned at the subtask level? Thanks for your video - great looking dashboard.
@echolocity Ай бұрын
You can configure what columns/fields show up on the card. Click on the gear icon! - More functionality coming soon as Smartsheet rolls out boards vs just cards
@annetteoverton5819 2 ай бұрын
Nice! Thank you.
@echolocity Ай бұрын
Thank you! It is always good to weigh the pros/cons of managing multiple forms instead of using conditional logic to show and hide fields. It typically comes down to whether the order of the fields matter, and if the form admins are the same or different.
@lebomolefe1206 2 ай бұрын
What is this?
@echolocity 2 ай бұрын
Hi Lebo! This video demonstrates how to add a new project using Teamwork.com work management software
@KevinK-in5vk 2 ай бұрын
Is there a template for project status dashboard in smartsheets that I can use as a baseline template?
@echolocity Ай бұрын
There are many template sets in the Smartsheet solution center. Unfortunately Smartsheet doesn't allow partners like us to post templates in their Solution Center. www.smartsheet.com/marketplace/partners/echo-consulting
@pedrotodorovski529 2 ай бұрын
Nice content! Fresh and updated. Congrats :D
@echolocity 2 ай бұрын
Thanks! We are following the upcoming changes closely.
@ruteshrudra6320 2 ай бұрын
Are we able convert from sheet to report directly
@echolocity 2 ай бұрын
You can pull a metric from a sheet, or you can do a chart from a report. Often times we will pull a metric from a sheet, but when you click on the metric widget on the dashboard have it open a report. Hopefully that answers your question, but if not, please provide a bit more context and hopefully we can help!
@bharatpotdar2667 2 ай бұрын
1. Is it possible to give read-only access to some members of the plan (in the planner plan 1) ? I don't want anyone to edit the plan and mess up a neatly planned project. I'd rather keep 1-2 members who can progress the tasks, and the other members to only view the tasks. 2. If the above case is true, then do we still need to buy planner plan 1 licenses for all members or only for those members who require write/edit permissions?
@echolocity 2 ай бұрын
1. Hmmm, we've used work arounds in PowerApps and PowerBI reporting for leadership / roll-up reporting where you don't want individual users to edit tasks. I don't believe that Microsoft has rolled out view only permissions to Plans yet. - side note, We have been advising to use M365 groups vs Teams in some cases to help with rights/access management. It depends on the scenario / use case though. 2. Microsoft is always adjusting their licensing models, however, at the moment, basic plans are included in Teams, so you will only need licensing IF you are using premium plans.
@MegoonGA 3 ай бұрын
Hi, I have set up an automation to move a row once a check box is checked but it is not moving on its own and when I go to the automation and select run now it moves every row whether the box is checked or not. Any advice?
@echolocity 2 ай бұрын
Do you want to share a screenshot of the automation? It may be a conflict in your logic, but without seeing how you set up the automation, we can't be sure. We don't have any reports from our clients of issues with the move row automation, and we use it in a lot of our Smartsheet implementations. Hopefully you found a resilient solution!
@minimaker2148 3 ай бұрын
Is there a way we can create MS Teams planner tasks from Smartsheet cards?
@echolocity 2 ай бұрын
YES! Power Automate integrates with Smartsheet directly now. Lots of great use cases but make sure you have a clear plan for single source of record and whether it will update bi-directionally or only in one direction.
@vladiovu 3 ай бұрын
Thank you! very helpful! Is there a way to have this dynamic in case more people are added to the sheet later?
@vladiovu 3 ай бұрын
I keep getting the "#INCORRECT ARGUMENT SET" any ideas?
@echolocity 2 ай бұрын
Yes and No. It really depends. There are cases where you have to update metrics sheets to include more values explicitly, however there are formula work arounds and skipping blanks etc that can help make it more resilient to change. Sometimes we use a report off of a metrics sheet or something along those lines... Smartsheet often upsells their Pivot Table Add-on for organizations that have lots of use cases of this sort. We've also used other add-ons to work around this use case like DataMesh and Dynamic View, etc.
@echolocity 2 ай бұрын
So many ideas - one of the most common issues with formulas. Did you get it fixed?
@joycechen2394 3 ай бұрын
Thank you! I have a quick question for empty values, is that possible to exclude those category fields in bar chart if there is 0 value?
@JamesDavid-f2l 3 ай бұрын
Great video. So this lets me ADD a Kanban card view to my dashboard. But what if what I actually want is totals (report) from that Kanban board. Maybe I just want to have a chart that looks at my Kanban board and pulls in the Total # of cards based on status (open/closed/blocked). Maybe I want another frame on the DB that shows how many were High Priority or by country or product. And then have it all update in real time so as Kanban cards are updated, the DB updates. I presume I have to build reports at aggregate the Kanban cards and all the intended fields I want summarized/totaled and then go add those reports to my Dashboard. Is this relatively easy or hard when try to build charts like this when the base method is Kanban cards (not sheets). Then I start thinking about trending and I worry my dashboard can't show me trends because it will always be pulling the current state - not the state we were in last month vs last week vs today. Thoughts? Thanks in advance
@echolocity 2 ай бұрын
Kanban boards are just a view of the sheet/table, so yes, typically we use reports for the Dashboard charts / metrics, but the card view when we want to see them explicitly on the dashboard. We use a current week and previous week formula to capture some of the metrics and keep it resilient / up to date. Hope this helps!
@JamesDavid-f2l 3 ай бұрын
Great video. So this lets me ADD a Kanban card view to my dashboard. But what if what I actually want is totals (report) from that Kanban board. Maybe I just want to have a chart that looks at my Kanban board and pulls in the Total # of cards based on status (open/closed/blocked). Maybe I want another frame on the DB that shows how many were High Priority or by country or product. And then have it all update in real time so as Kanban cards are updated, the DB updates. I presume I have to build reports at aggregate the Kanban cards and all the intended fields I want summarized/totaled and then go add those reports to my Dashboard. Is this relatively easy or hard when try to build charts like this when the base method is Kanban cards (not sheets). Then I start thinking about trending and I worry my dashboard can't show me trends because it will always be pulling the current state - not the state we were in last month vs last week vs today. Thoughts?
@broderp 4 ай бұрын
I must have a very specific use case that no one does because so for 100% of the videos I've watched do not help or do not have enough detail. I need to "upload" fields from an excel sheet to a Smartsteet so I can track responses from multiple excel forms filled out that are in a location with unique names. (Basically someone fills out an excel form and submits it. It goes to a mailbox. I need Smartsheet to see the new file and send out an email to have someone review the form and approve. I guess no one does this. My work has users locked out of admin. privileges for installation of programs, so I need to be able to present a good case to spend and have IT download/ install this on my system. I have Smartsheet and Office D365 in an Enterprise environment.
@echolocity 4 ай бұрын
I think there are several ways to solve for what you are looking to do, but it may not be Data Shuttle - it may be Power Automate, or a combo depending on the specific triggers you need. We have definitely added rows in Smartsheet based on emails in a shared box. We have also added meetings and other components in Outlook from Smartsheet, etc. If you'd like to discuss an engagement for specific support, we are happy to meet with you! We can also put your request on our video backlog. All the best!
@RodneyClang 4 ай бұрын
I can't seem to get a Premium plan to show in Loop, it doesn't show up in Recent Plans when going to add. Have you verified this should work? Thanks for the vid!
@echolocity 4 ай бұрын
It may still be in early adopter program - we are checking with our Microsoft Partner rep. Stay tuned!
@aldehoyos6803 4 ай бұрын
Thank you guys for posting this video, always help whenever I get stuck. Smartsheet is a massive SaaS platform and it gets easy to forget unless your knee deep in it every single day.
@echolocity 4 ай бұрын
Our pleasure! Glad it helped! Thanks for the comment and following our content!
@themauvefox 4 ай бұрын
Is there a way to move the entire Q2 section to a different project listed on the left? I want to make folders on the left that say design in progress, waiting for sample, in production, etc. Once one design is done, I want to move the project to the waiting for sample project. We create hundreds of products so I want them in different folders/ projects to make it less cluttered. I do like how you changed the tasks. However I also wanted the Quarter 2 title and all the tasks underneath it to move. The Quarter 2 title would be the product name, like "Turtle Plush" Also is this feature of switching the project in the free version?
@andreosmond2214 4 ай бұрын
On the chart when you added Project Name, and it created "Count of Project Name" can you edit that if would rather it was Sum of Projects? I want to know the sum of values, and it is giving me the count. Thanks!
@echolocity 4 ай бұрын
Yes, you can use the "Summarize" option for Count, Sum, Average, Min, Max in reports. Each column can be Summarized uniquely, with the Groups ("Group by") providing the roll-up values. Reminder / FYI - if there are rows without values, they do not get counted or summed, which is why our consultants train to use a column where every row has a value in that column so that an accurate count is provided.
@abisyaiputra9614 5 ай бұрын
Awesome instruction! I made it to work in my practice sheet! Although i have a question, How to let Metric Sheet' data automatically update, after changes are made in the referenced sheet? I've tried to make some update on the main sheet, but the Metric did not change.. The only solution i could come up with is by updating the Formula to have the same formula over again and refresh the sheet. Is there any other way?
@echolocity 4 ай бұрын
Hmmm, it should push after you save the underlying sheet data and refresh the dashboard. Sometimes we use a date record automation to record a date every day in the metrics sheet so that the sheet refreshes. I may be missing something since you mentioned repeating the formula, which I'm not sure why that would help / be necessary.... Perhaps a bit more context?
@dchomes 5 ай бұрын
Very helpful. Thank you.
@echolocity 5 ай бұрын
Glad it was helpful!
@andreimurariu 5 ай бұрын
Hi Caroline! In a premium planner plan, will I be able to assign a task to a colleague that doesn’t have the Planner premium subscription?
@echolocity 5 ай бұрын
Great question! I haven't found a straight answer from the Microsoft sites on this but I have been testing. Right now, it is possible to assign someone a task from a Premium Plan who does NOT have an extra license. I.e., they don't have the option to "create" a Premium plan when they try to create a plan from Planner in Teams but they CAN see and edit tasks that are assigned to them from Premium Plans.
@quatecreative3360 5 ай бұрын
Perfect, thanks!
@Gapcreations 5 ай бұрын
Thanks for the detailed video and appreciated your efforts. I have scenario- I have 10 different sheets with individual data and same structured fields. Consolidated all the details with reports and how do I create a metrics? Currently cannot reference the report for metric calculations. Is there any suggestion?
@echolocity 5 ай бұрын
Hi @ganeshap23 - Glad to hear you liked the video. We have another video on metrics that may help you further: kzbin.info/www/bejne/Y3KZla2Zl6lmgqM
@Gapcreations 5 ай бұрын
@@echolocity thanks for sharing the video..this would be a great help
@michelesinger13 5 ай бұрын
The delivery of this tutorial was one of the best I've ever seen on KZbin. So many tutorials will spend way too much time explaining things the long drawn out way. This channel will now be my go to channel for all things Smartsheet.
@echolocity 5 ай бұрын
Awesome! We are really glad it was helpful!
@cataytimo 5 ай бұрын
did you use a specific template for this or did you manually created most of the columns? for instance: problem to solve/opportunity, proposed solution, etc. i wonder if there's a template that has most of those columns already
@echolocity 5 ай бұрын
Hi @cataytimo - all of the templates/sheets in the video were created by our team. Let us know if there is anything else you need help with.
@JenniferSlack12 5 ай бұрын
About time they got this feature. However, I went looking for this today and could not find this.
@echolocity 5 ай бұрын
Hi @JenniferSlack12 - unfortunately, ClickUp went through a big revamp after this video was filmed and, for some reason, this setting does not exists anymore.
@furikakez 2 ай бұрын
@@echolocity So there is no way to change the default style / size of a document ?
@dcasuto 5 ай бұрын
Thanks! Great video!
@echolocity 5 ай бұрын
Glad you liked it!
@ReneeTozzi 6 ай бұрын
Hello and thank you for your video. I have a question, though, as my formula is not working properly. At 2:20 in the video, you search the TODAY Function in the top left of the screen and it pulls up the reference to your source sheet. Is there a TODAY Function formula in the column you are referencing on the source sheet? I have tried this formula/function numerous times and it does not come up the way yours does.
@echolocity 5 ай бұрын
Hi @user-cr8jl4su4q. No, the only TODAY function was written during the video. The other sheet is just referencing the date.
@ReneeTozzi 5 ай бұрын
@@echolocity Thank you.
@donovanvaz3289 6 ай бұрын
Hi I don't suppose you can show how to display the successor task name please? I've seen it on another video using the =JOIN(DISTINCT(COLLECT function, but I can't understand the logic and keep getting Incorrect Argument Set. Any help gratefully appreciated.
@echolocity 5 ай бұрын
Hi @donovanvaz3289 - for more information, please check out this thread from the Smartsheet community: community.smartsheet.com/discussion/84257/successors-testing