6 Ways You Can Use Smartsheet to Manage Events


6 Ways You Can Use Smartsheet to Manage Events

Volunteers work at the registration kiosk at the Smartsheet ENGAGE customer conference

Event management, in my eyes, is very similar to project management; the key to success is keeping the management side light and simple.

This is especially true when we organize and plan for our annual Smartsheet ENGAGE customer conference. This event brings together the global Smartsheet community for four days of learning and best-practice sharing across multiple roles and industries.

Our end goal is for attendees to head back to their companies energized and ready to make an impact using the Smartsheet platform.

Prior to Smartsheet, I managed events using a mix of static spreadsheets. While that got the job done, it was woefully inefficient. I’ve saved so much time using Smartsheet to manage all the little details that go into producing an event.


Make Better Decisions, Faster With Dashboards

For example, we created a shared workspace and Smartsheet dashboard to track key deliverables and deadlines, with underlying sheets to manage the event budget, sponsorship deliverables, demand generation plan, signage and collateral, registration tracking, and more.

We even built the conference agenda in Smartsheet using Card View to ensure we weren’t double-booking our presenters. Our core planning team is always on the same page, with shared visibility and accountability of what’s on track or at risk.  

What’s proved especially helpful is the ability for our event team to share progress notes and add documents — all in one centralized location — by attaching them to our tracking sheet.

And the option to track deliverables using different workflow views — Grid View, Gantt View, Card View, or Calendar View  makes it super easy to see where we are behind (or ahead!) of schedule. Whether you’re new to event marketing, or a seasoned pro, I think you’ll find these following six tips and tricks helpful.

1. Provide Visibility, Transparency Across Your Company

We created a Smartsheet dashboard — without any IT help — to share top-level events metrics and updates with our entire organization.

With the dashboard in place, we didn’t need to answer one-off questions over and over again. Since anyone can go to event dashboard and see the real-time metrics at a glance, we met questions such as “How many registrations do we have versus the goal?” or “Where are we with our sponsorship sales?” with an easy answer: check out our ENGAGE dashboard!

If you’re excited to build your own dashboard, Smartsheet Business and Enterprise Plan customers can download the free Event Registration and Tracking template set. It includes a sheet with an auto-calculating workback schedule, a dashboard template, and an event planning sheet to help get you started.


8 Ways to Make Your Meetings Less Costly, More Productive

2. Transform Your Planning Meetings

It’s wise to avoid drawn-out email threads and manage your meetings directly in a sheet. We use a single sheet to manage our planning meetings so everything is in one place — from the agenda to the presentation deck, including additional supporting materials and action items.  

While sheets are super versatile, we’ve been able to move even faster by using the Smartsheet integrations for Slack and Workplace by Facebook. We can receive automated notifications in our Slack channel and can quickly share key updates with groups using Workplace. Plus both of these apps work great on desktop and mobile.   

3. Give Speakers a Best-in-Class Experience

One of the primary reasons our customers attend ENGAGE (and most conferences in general) is to connect with and learn from their peers. We use Smartsheet to coordinate dozens of internal and external speakers across the event agenda, and ultimately want to ensure all of our conference speakers are well prepared before and during the event.


Easily Access Mobile Forms to Quickly Collect Data From Anywhere

We collect each speaker’s contact information, travel details, bio, and headshot via a quick form. We also use a shared dashboard to communicate key updates, deadlines, and deliverables, as well as scheduling rehearsal times and collecting final presentation decks and materials. Many of our customers speak at various industry conferences each year and have raved about how easy it is to use Smartsheet to manage this process.   

4. Manage Your Demand Generation Plan

Most events include a mix of paid, earned, and owned channels to help drive registration. For ENGAGE, we have over 100 individual tactics to manage across multiple platforms. We use Smartsheet to manage all of these workflows and details, including due dates, task owners, links to copy docs, and attaching creative files and thumbnail images directly to the task’s row.

Anyone with permissions in the sheet can upload files directly to a row or via Dropbox, Google Drive, OneDrive, and other popular cloud-based file storage platforms.

5. Raise the Bar for Onsite Operational Excellence

One of the reasons I love managing events is seeing all the planning and details come to life on site. When it comes to our onsite production schedule, I use Smartsheet as a literal checklist for each area of the event.  

For example, I build out an inventory of everything that’s needed at the registration desk and then double-check during setup that everything is at the event and accounted for. That said, anyone who’s managed an event, large or small, knows that everything doesn’t always go to plan.

The best event professionals keep smiling and adjust along the way. When we’re all running in multiple directions during the event, our team needs to stay connected to update each other on any issues. This makes those Slack and Workplace integrations very handy. We can make lightning-fast requests and approvals on the fly, all accessible via the Smartsheet mobile app.


5 Reasons to Attend Smartsheet ENGAGE’18

6. Gather Feedback, Evaluate, and Improve

Gathering feedback from your attendees is such a valuable way to debrief and learn. We use forms to quickly create multiple surveys — one version for our customer attendees, another for speakers, another for sponsors, and an internal survey of our employees.

This allows us to gauge if we met the mark or fell short on key areas of the event, how we performed against the previous year, and how we can improve the experience next time around.

Combining and reviewing all of the survey responses helps us make data-driven decisions on what to stop, start, continue, or improve for the upcoming year. We can feed these results into our standard processes and automate to make future events even more engaging for our customers.

If you want to learn more about Smartsheet ENGAGE, check out our highlight video from last year’s conference:


Event Planning and Project Management

I really enjoyed your post. As a long time Marketing Specialist and Event Planner I am learning all kinds of helpful new tricks and tips from the PMs I now work with at Advisicon. Previously having worked in book publishing it is very interesting/beneficial to learn about project management best practices and to relate them to event planning.

Event Planning

Lindsay thanks for the great shearing about event management i appreciate your post especially "Event Marketing" is best one in my point of view. I am project manager at U-cube enterprise and as you know how much tough this job as a manager, i always try to keep my self update from new tools and techniques for my self career growth. Thanks.

Very Nice Article

Lindsay, this was a great article and very on point. I have a side organizing/decluttering business and I have found that managing home projects are just as important as managing a project at work. Same goes for event planning. There is a lot to do and things can get lost in the weeds if you don't track what needs to happen and who needs to handle what. Project Managers have a great skill that can be applied to many areas. Great reminder for all.

Great! You have mentioned

Great! You have mentioned some vital points in your article which are very much practical. It is your intellectual ability and the presentation skills that will help you to make the Event successful. As an Event manager you have to make sure that every member of your team should give their best to complete the particular event as everyone is equally responsible for that. Project management is a daunting task and one thing is clear that without proper planning and implementation you can’t complete the project in time. You really need some efficient team members to work with and remember they are the people who can make things for you. I am telling all these from my own experience and recently I have done a project on Social Awareness thanks to my team members.

Events Management

I would like to know how do one make sure that everything is in order in an event.That everyone can work with one another as a team.Secondly how does a person or company acquire sponsorship for an event?

RE: Events Management

Emily Esposito's picture
Hi Sifiso, planning an event definitely involves a lot of moving parts and it's important that everyone is on the same page, as you mentioned. Check out our Event Plan & Budget template here (http://www.smartsheet.com/solutions/event-plan-and-budget) to manage all details in one place and collaborate with other team members. Good luck! Emily

Very Helpful Blog

This is totally amazing information about managing event management. Thanks alot

50th wedding anniversary

Thank you for sharing this article, I enjoyed learning more about event planning and Smart spreadsheets. My siblings and I (4 in total) are planning our parents 50th wedding anniversary. What type of smartsheet template would you recommend? Working with a spreadsheet will be a great tool for us since two are in Canada, one in the Usa and I in Europe. I thank you again for the tips and if you have an specific template you recommend please let me know.

RE: 50th wedding anniversary

Emily Esposito's picture
Hi Evelyn -- Smartsheet can definitely help you plan your parents' 50th wedding anniversary. We'd recommend the Event Budget and Planning Template, where you can track due dates, tasks, budget and spend in one place and with your other siblings. Here is the link: https://www.smartsheet.com/solutions/event-plan-and-budget. You can also use the Event Registration Web Form to track RSVPs for the event: https://www.smartsheet.com/solutions/event-registration-web-form. Good luck! Best, Emily

This really helped thanks

This really helped thanks

Project manage your event planning

A very informative article.

Event Management,

Really the best info about Event Planning, i hope this is the best services.

Nice post on events.Thanks

Nice post on events.Thanks for sharing

event management

this site is very helpful in event management .Thnaks for sharing the post.

Add new comment