February PowerShell - What have you done? - PowerShell. Not a lot for me this month, mostly small stuff, but PowerShell is so helpful with everything I do these days! I am in the middle of a user account consolidation (in response to a SOC II audit), so my goal is to inventory them to determine if an account was intended for service (managed or unmanaged), shared mailbox/calendar, or interactive use by named person. This involved aggregating statistics from Active Directory and Exchange. I would grab things like last logon time (I didn't need super accurate up to the minute details, so LastLogonDate was good enough for me), description, OU, etc. - all the usual details... then I paired that up with Exchange mailbox info, if there was any.
If they had a mailbox associated with them, I'd grab details like when the mailbox was last accessed, by whom, how many items in the mailbox, date of last email, etc. That last part was really telling - I was able to very quickly separate out the shared mailboxes and figure out which ones were still active. Webforms for help requests - best practices | Smartsheet Community. Looking for input | Smartsheet Community. Sending alerts in advance of start date | Smartsheet Community. Smartsheet Community. Smartsheet Tips: Using Google and Smartsheet. You know how peanut butter is really good on its own, but even better when you pair it with something else (like jelly, a banana, chocolate, a graham cracker...)? Smartsheet is like that too – pretty darn great on its own, but even better when you pair it with something else. Like Google Apps and Google Drive. Since many of you use Google in addition to Smartsheet, this week we’ve got all the integration details for you. Getting Started with Google Apps and Smartsheet If you’re using Google Apps, make sure you’ve downloaded our app from the Google Apps Marketplace.
The Google Apps Admin for your domain just needs to click the ‘Add it Now’ button to install Smartsheet to your team’s domain – and voila! Small note, the email address you use for your Smartsheet account needs to match your Google email address for the integration magic to work. Integration Goodness – Here’s What You Get Update a sheet from your inbox. Make any changes you need to – add discussion notes, attachments, the works. Project Management Basics Not to Be Overlooked. From contributing writer, Robert Kelly, PMP: It's not uncommon to end up as a project manager through practical experience.
Chances are you're doing the things that have always worked for you, made your teams successful, and earned you promotions - without ever reading a book on project management or completing a certification course. What you may not know is that there is some basic project management knowledge and terminology that is very useful when working with other certified Project Management Professionals. Having some basic project management knowledge is worth it. It might even help you become better organized and lead you to yet another promotion. Basic Blocking and Tackling Let's cover some basic blocking and tackling of project management. Specifically, I want to cover the Work Breakdown Structure, the Project Schedule, and the Project Plan.
Work Breakdown Structure Every project has a few core requirements. Project Schedule Project Plan Learn Project Management Basics. Smartsheet Tips: 3 Shortcuts You Didn't Know. The busiest time of the year is in full swing - and who doesn’t love to save a little extra time? This week we’re featuring three often overlooked features in Smartsheet that can help you save a little time in your day.
Whether you’re looking to calculate a sum without a formula or want a different way to incorporate important emails into your work in Smartsheet, read on for a few quick tips. 1) Fill down information with Ctrl+D Looking for a way to fill down data in your sheet? Ctrl+D (command+D on Macs) is the unsung hero of keyboard shortcuts. First, click on the cell with the data you want to copy, or the formula you’d like to duplicate.Then, use your scroll bar to navigate to the end point (much quicker than dragging!)
For example, use Ctrl+D to fill down a formula in a sheet with many rows. 2) Instantly add up values without using a formula You don’t need to be a formula wizard to quickly calculate data in your sheet. Try this: 3) Save emails as attachments How about you? - Support Team. The Unofficial Smartsheet Guide to Being a Project Manager. It’s the list-making time of year, the time when people are thinking about fresh starts, big plans and even bigger wins. So here, just in time for your New Years resolution list, is the unofficial Smartsheet guide to upping your project management game in 2014. The Unofficial Smartsheet Guide to Being a Project Manager | An infographic by the team at Smartsheet Embed The Unofficial Guide to Being a Project Manager on your site: Copy and Paste the Code below <img src="/sites/default/files/haymaker/HowToBeProjectMngr.png"><br /> The Unofficial Smartsheet Guide to Being a Project Manager | An infographic by the team at <a href=" The Unofficial Smartsheet Guide to Being a Project Manager Read widely, especially about human psychology.Learn how to play poker.
From the project management minds @Smartsheet, the tool millions of PMs worldwide choose to work more productively than ever before. Project Manage Your Event Planning. From contributing writer, Lindsay Scott: For a number of years I’ve been involved in a specialist project management group – PMOSIG. A voluntary specialist interest group dedicated to PMOs – Project, Programme and Portfolio Offices. Being part of a voluntary group which plans, organises and delivers conferences and meetings has been an interesting experience. Events management, in my eyes, is a lighter version of project management. The key to success is keeping the management side light – or if you prefer K.I.S.S. – Keep It Simple Stupid! So, even though everyone in our voluntary group has a project management background, in the early years we didn’t use any tools to plan and manage conferences. No. The simplest lesson we learnt, one that made us change our whole event management approach, was that team members needed to know where we were within the plan, what each of us needed to do, and when each task was due (and without the stress and hassle!)
Brainstorm and Planning Evaluation. Release Notes. New in Smartsheet: See Images in Your Sheets. When you have one central hub for all of your file reservoirs, collaborating on content and other deliverables becomes faster, streamlined, and formalized. Smartsheet helps you achieve that. Between in-app attachments and our Google for Work, Box, and Dropbox integrations, you’ll be hard-pressed to find a more efficient way to organize accessibility to all of the moving assets of an enterprise. That said, we are constantly looking for ways to simplify work.
We have a feeling our latest upgrade will be championed by our visually-inclined professionals. Attaching images to a row is helpful, but in some cases, having those images readily viewable offers a whole new way of comparing and contrasting or adding that extra bit of insight to data. How to add an image to a cell In Excel and Google Sheets, images placed in a spreadsheet aren’t actually inserted into a cell. Want to try for yourself? Right-click the cell you wish to contain an image.Choose Insert Image... from the dropdown menu.