Kelly Anthony's blog

Adding formulas into your sheets is one of the handiest ways to automate your work, save time, and eliminate unnecessary hassles. While you update details like financials or event attendees, having the right formulas in the right place on your sheets helps to keep the big picture in sight and communicate the most important details to others. Before you dive into some of the more complex formulas in Smartsheet, it’s helpful to understand some of the basics and how they work. Read on for an overview of range formulas. What is a range? Some types of formulas, like SUM, SUMIF, COUNT, and MIN look across a collection of two or more cells to calculate their total.
Read more

Lessons Learned Building Mobile Applications

At Smartsheet, we’re constantly refining and improving our product, including our mobile apps. Over the past years, we’ve put tremendous effort into building a great user experience via native mobile apps for iPad/iPhone and Android. It’s why half our engineering resources are committed to delivering the iPhone, iPad and Android devices
Read more
There are several personal characteristics that senior executives often share. They’re big thinkers. They’re storytellers. They’re innovators. They’re hard workers. Those descriptors definitely characterize Johnny Levy, President of DataJoe LLC in Boulder, Colorado. He admits, however, that managing the myriad of details is not his foray. “All my life I’ve struggled with managing the details,” Levy says. “I’m extremely busy and I have to work hard to follow through on all the tasks I need to do.
Read more

Roundup: Top 5 Project Management Posts

With slower summer schedules, it’s a great time to get organized and ready to tackle the rest of the year. Whether you’re looking for quick, easy techniques for planning your next workback schedule, figuring out what a Gantt chart is, or looking for some tips to keep your mind sharp and planning skills up to speed, check out these top project management posts from the Smartsheet blog. You’ll brush up on the basics in no time and head into Fall ready to tackle whatever the rest of the year throws your way.
Read more

Customer Spotlight: TECHO

TECHO, a youth led non-profit organization present in Latin America and the Caribbean, recently shared how they use Smartsheet to increase productivity, improve efficiency and ultimately reach their goal...which is to change the world by eliminating poverty in the slums of Latin America. Marcos Cavanagh, Corporate CFO for TECHO, explains below how they effectively use Smartsheet to work with a young global workforce, keep actions transparent and hold the dispersed team accountable to overcome poverty. Founded in Chile in 1997, TECHO has been working to permanently eliminate poverty throughout Latin America. We’ve seen huge growth over the past 17 years and maintain locations in 19 countries.
Read more

Tip: Create a Calendar Dashboard in 7 Quick Steps

A great way to stay organized and not let anything slip through the cracks is to make sure all of your important dates are in one handy calendar. Follow these simple steps to make your own master calendar in Smartsheet. Say goodbye to creating yet another task list or individually publishing massive plans to your calendar. A master calendar shows you a roll up of task assignments, meetings, and deadlines that are spread across multiple sheets. When you use cell linking to create your calendar, dates are automatically updated in your master calendar whenever they’re changed in the source sheets.
Read more
Depending on how many projects you’re involved in and the size of your team, there’s a good chance you have quite a few sheets in Smartsheet to keep you on track. Workspaces and folders are great tools to help you stay organized, but what if you want to quickly search across all of the sheets you own and pull key information together in one spot?
Read more

Tips from Support: 3 Things to Know About Columns

One of the reasons so many teams love Smartsheet is that it looks like a familiar spreadsheet, with tons of brilliant collaboration features layered in. While there are many differences between Smartsheet and other online spreadsheets, one of the biggest (and often overlooked) differences with Smartsheet is the power built into the different column types available in each sheet.
Read more

Pages