Best Of
Re: July Question of the Month - Join the conversation and receive a badge
Wow, this is a great question. Well during COVID, I bought a home, we are a one-income household (like many people these days), but I managed to afford a big house for us. We have the ability to host for the holidays, as we are in a central location for everyone. Yes, it is a lot of work cooking and cleaning all week. But there is nothing more important than family! In fact today (7/3) in my grandson Liam's FIRST birthday. And despite owning our home for only 4 years we have paid off $40K and have over $100K in equity. In our down time my husband. These are the moments I live for!
SherryFox
Re: July Question of the Month - Join the conversation and receive a badge
My personal fitness goals are going well. Have I missed a few gym days? Maybe… Overall though I've never been healthier or felt [physically] better!
Nik Fuentes
Re: July Question of the Month - Join the conversation and receive a badge
What is a personal goal you've set for yourself this year, and how is it going?
I made a promise to myself, when my kid was more independent (now 17+), I would focus on me more. This year I have taken steps to do just that and am on my wellness track- mental and physical. It's been painful and peaceful, eye opening and thought provoking.
Jen Lawson
Re: July Question of the Month - Join the conversation and receive a badge
My goal was to pass the Core Product Certification test…and I did June 29th 😁
TamieKing
Re: July Question of the Month - Join the conversation and receive a badge
Even though I didn’t share a goal back in January, I’ve had a few personal milestones in mind this year—and I’m excited to share that I’m making solid progress!
😉 Get Smartsheet Certified – Completed just this past weekend!
😁 Understand Formulas – After six weeks of focused study for the certification exam, the concepts finally clicked.
😃 Reapply for the Overachievers Program – Submitted!
☺️ Gain deeper knowledge of core Smartsheet functionality – With three years of daily use under my belt, I’m continuing to explore features and best practices every day.
It feels great to pause and reflect—this software continues to empower me and challenge me to grow. Looking forward to what the rest of the year brings!
Wilen FL
Re: July Question of the Month - Join the conversation and receive a badge
To learn Spanish, and it is going badly, because I have not done anything about it!
But this is a good prompt for me to start.
Re: Work with Flow - A Space Story
I've built multiple projects leveraging nearly every aspect of Smartsheet’s capabilities — projects that previously required custom systems built by our App Services development team. With Smartsheet, I’ve been empowered to deliver solutions that were once unimaginable or would have taken months to develop.
Some of these projects started as simple Excel files. Now, they’ve evolved into dynamic, organic, near self-sufficient workflows that connect and communicate across every branch of the organization. Collaboration has increased exponentially, and the user-friendly nature of the platform has driven higher engagement across teams.
Smartsheet feels like a blank canvas of possibility. When it comes to building solutions, the question is no longer “Can it be done?” but “How do I want to do it?” It's both challenging and rewarding — because you see real results. Watching a project evolve from idea to development to deployment, and hearing users say it’s improved their daily work, is incredibly fulfilling.
Wilen FL
Re: How can I calculate and display a percentage ratio between two numeric columns in Smartsheet formula
You can do the basic division and then format the column to show as percentages.
=[Credit Consolidated]@row / [Credit Required by Proposal]@row
Paul Newcome
Re: Formula question
Hi @DYou
Your formula had a syntax error in ISBLANK[Milestone Variance]@row — square brackets must be used inside the function like ISBLANK([Column Name]@row ).
Second, there are four IF statements, so you must have four closing parentheses ). If even one is missing, Smartsheet will throw a syntax error.
However, we can simplify the logic slightly since the final case (greater than 0) is the only remaining possibility. Here’s the simplified and clean version (with only 3 IFs and 3 closing )): ( →My second formula)
Yours
=IF(ISBLANK[Milestone Variance]@row ), "", IF([Milestone Variance]@row = 0, "On Time", IF([Milestone Variance]@row < 0, "Early", IF([Milestone Variance]@row > 0, "Late", "")))
Mine
=IF(ISBLANK([Milestone Variance]@row ), "", IF([Milestone Variance]@row = 0, "On Time", IF([Milestone Variance]@row < 0, "Early", IF([Milestone Variance]@row > 0, "Late", ""))))
or
=IF(ISBLANK([Milestone Variance]@row ), "", IF([Milestone Variance]@row = 0, "On Time", IF([Milestone Variance]@row < 0, "Early", "Late")))
Re: Introduce yourself & get to know your peers!
Hello everyone, my name is Mark and I'm a GM in a manufacturing company. I was born in Florida USA but have travelled the world and now have settled down in Singapore. I've always been a big fan a data and became a master at MS Excel. I created interactive dashboards that made people ask me what platform that is and when I said Excel they didn't believe it could do that. However, the cons to Excel is that it is not very good as a collaborative tool. Which led me to search far and wide and I landed on SS way back around 2008.
I couldn't get it to stick in the company at that time as MS Office was still king and online collaborating platforms were still in their infancy. I tried again around 2018 in my previous company. I bought it with my own money and proliferated out to a small group of managers. We ended living and breathing in SS. Creating huge data sets, workflows, links and dashboards. Eventually using SS as our source data for bigger visual platforms like MS Power BI. Once we hit that level, SS took off in my company and we ended up purchasing over 100 licenses.
Fast forward to today and I'm in a new company for about 3 months and I am surprised that no one here has even heard of SS. So again, I just purchased 3 business license and I'm looking forward to introducing this wonderful product and training this new team to use this collaborative tool in finance, manufacturing, quality and beyond. Also looking forward to collaborating with all of you and learning new tips and tricks.
Mark D


