Smartsheet Inc. (SMAR) Q2 2022 Earnings Call Transcript

Smartsheet Inc. (SMAR -0.73%)
Q2 2022 Earnings Call
Sep 07, 2021, 4:30 p.m. ET

Contents:

• Prepared Remarks
• Questions and Answers
• Call Participants

Prepared Remarks:

Operator

Good day and thank you for standing by welcome to the Smartsheet second-quarter fiscal 2022 earnings conference call. At this time, all participants are in a listen-only mode. After the speakers' presentation, there will be a question-and-answer session. [Operator instructions] Please be advised that today's conference is being recorded.

[Operator instructions] I would now like to hand the conference over to your speaker today, Aaron Turner, head of investor relations. Thank you please go ahead, sir.

Aaron Turner -- Head of Investor Relations

Thank you, Tabitha. Good afternoon and welcome, everyone, to Smartsheet second-quarter fiscal year 2022 earnings call. We will be discussing the results announced in our press release issued after the market closed today. With me today are Smartsheet CEO, Mark Mader; and our CFO, Pete Godbole.

Our chief strategy and product officer, Gene Farrell will also be available during the Q&A. Today's call is being webcast and will also be available for replay on our investor relations website in investors.smartsheet.com. There is a slide presentation that accompanies Pete's prepared remarks, which can be viewed in the event section of our investor relations website. During this call, we will make forward-looking statements within the meaning of the federal securities laws.

We have based these forward-looking statements largely on our current expectations and projections about future events, financial trends, and our expectations around the impact of COVID-19 on our business. These forward-looking statements are subject to a number of risks and other factors including but not limited to those described in our SEC filings available on our investor relations website and on the SEC website at www.sec.gov. Although we believe that the expectations reflected in the forward-looking statements are reasonable our results -- our actual results may differ materially and adversely. All forward-looking statements made during this call are based on information available to us as of today.

We do not assume any obligation to update these statements as a result of new information or future events except as required by law. In addition to the U.S. GAAP financials, we will discuss certain non-GAAP financial measures. A reconciliation to the most directly comparable U.S.

GAAP measures is available in the presentation that accompanies this call, which can also be found on our investor relations website. With that, let me turn the call over to Mark.

Mark Mader -- Chief Executive Officer

Thank you, Aaron, and thanks to everyone for joining us today for our second-quarter earnings call. Q2 was a very strong quarter for Smartsheet, our customers, and partners. Revenue grew 44% to $131.7 million, billings grew 47% to $242.9 million, and our dollar-based net retention rate, which incorporates all of our customers improved by three points to 128%. We ended the quarter with over 9 million users in our ARR grew 10% quarter over quarter to over $0.5 billion.

Our 1,856 customers with ACV over $50,000 now account for more than half of our ARR. In Q2, our average domain ACV grew 42% year over year to $5,915 and expansion within our base included and 143 customers increasing our ARR by more than $50,000 of 81% year over year. And 49 customers a Smartsheet quarterly record increasing their ARR by more than $100,000 up 158% year over year. Additionally, we had two expansions of over $1 million in the quarter and now have 22 customers with ARR over $1 million compared to 15 last quarter.

Enterprise customer deployments demonstrate Smartsheet momentum in serving the scaled needs of those customers. Our industry diversification remains broad with our largest industry accounting for just 12% of our ARR. Growth remains strong across industries including technology with customers such as Zoom communications, Hitachi, Intuit, and PayPal. And in professional services with companies such as BDO, Insight Global, and Jacobs Technology.

Q2 was a high-impact quarter for companies in healthcare and life sciences. With the year-over-year ARR growth of over 50%. This growth was supported by expansions from companies including Allscripts Healthcare Solutions, Amgen, Prime Healthcare, Yale New Haven Hospital, Vertex Pharmaceuticals, CommuniCare Health Systems, and Medtronic. In addition, we saw strong performance across retail with expansion from companies such as Burlington Stores, and Gap Inc, media and entertainment with expansions at NBC Universal, and The New York Times, and manufacturing with Johnson Controls, and Whirlpool.

Our customer acquisition was strong in Q2 as well, thousands of new customers chose Smartsheet this quarter including wins at Sky News Australia. Momentus Space, SMG, New Hampshire Department of Health and Human Services, Kestrel Coal, and unified field services. What these customers have in common is a shared belief that Smartsheet is ideally suited to meet their broad and ever-changing needs. At its core, Smartsheet is an enterprise-grade dynamic work management platform designed to empower business users to transform how they work.

We go to market using a land and expand model that often starts with a team or department choosing Smartsheet to solve a transactional use case like project management, task tracking, or goal management. The solution then grows through a low friction viral motion when users share their work and engage with those inside and outside of their organization. Where we excel is our ability to enable customers to extend beyond transactional use cases to support transformative operational workflows across their business. In part, this is made possible by our flexible data model.

Our Advanced premium platform capabilities and work apps no-code solutions. Our flexible data model combines the agility of a spreadsheet with the power of a database. Smartsheet Advanced enables customers to configure and execute workflows between Smartsheet and other systems of record, execute high-volume processes, and change management at scale. And empowers IT to centrally manage compliance and security across multiple Smartsheet plans.

And work apps empower business users to configure no-code apps and share these curated solutions while maintaining visibility and control for IT. In Q2, with the launch of Smartsheet Advance, we saw immediate resonance with prospects and customers signing over 100 deals that included Advance. One example of a customer that expands was Mimecast. Mimecast enterprise PMO uses Smartsheet to support objectives related to growth and digital transformation and with Advance will now leverage Smartsheet to optimize programs and processes outside of that PMO.

Including marketing operations, channel partner onboarding, sales rep onboarding, and large customer account planning. Mimecast considers this investment as a way to remove friction and accelerate the speed of deployment for future Smartsheet solutions that leverage premium capabilities. In Q2, Smartsheet Advance influences significant expansion with a leading provider of equipment and services for data centers. This customer's IT new product development and marketing departments are at the core of this enterprisewide deployment.

With the Advanced platform's premium capabilities the customer will drive additional value and end-to-end cycle time improvements across critical parts of the business. Smartsheet Advance is also resonating with customers outside the US. One example, HIT Holz, a large German container and packaging manufacturer deploys Smartsheet Advance to increase productivity by doubling the project capacity and to capitalize on growing e-commerce trends by providing visibility across complex ever-evolving project needs. A key selling point for the customer's adoption of Advanced with the benefit of extending our platform to capture new use cases and further simplifying the implementation process.

Beyond Advance, we continue to see customers using our platform at scale. Data shuttle which enables scheduled data transport between Smartsheet and other systems of record processed over 1.7 billion records in the past 30 days growing close to 20% month over month. Proofing was used by customers to collaborate on the creation of digital content 370,000 times in the first half of the year. Representing year-over-year growth of over 350%.

Customers have created 40,000 work apps since the launch without writing a single line of code. And customers leverage brand folders to manage over 50 million digital assets as of Q2. A 200% increase year over year and content delivery views in Q2 averaged 1.4 billion per month. And we continue to innovate for our customers and launch new capabilities.

To support our global and non-U.S. customers' data privacy compliance requirements, we will announce the availability of Smartsheet Regions this quarter. The first region located in Frankfurt, Germany enables customers to instantiate Smartsheet plans in the region and does not require any customer content to be shared or routed through our U.S. region.

In the wake of changing regulations and heightened awareness on the subject, our research indicates that enterprise buyers are increasingly sensitive to fully not partially solving for data residency. We look forward to announcing the availability of additional Smartsheet Regions in the coming quarters. Our partner ecosystem continues to thrive as well. In Q2, we launched an integration with HubSpot, making it even easier for customers to enable bi-directional real-time sync of data between Hubspot and Smartsheet.

And we also expanded our partnership with MuleSoft. With MuleSoft connector for Smartsheet customers can manage a variety of business processes ranging from sales pipelines to events schedules. In addition to technology partners, our channel partner program is ramping well. We now have 650 channel partners.

And in Q2, partner influence bookings grew 93% year over year. I'm proud of the way our growing team continues to execute across the many dimensions of the business. Around the world, people are choosing Smartsheet for simple to sophisticated use cases, whether mobilizing a team of creators or scaling a data-intensive workflow with embedded calculations, or reporting on data from disparate internal systems. And they do that at enterprise scale using a no-code interface that every single person can engage with.

In the near future, everyone using a computer at a desk, a device in the field, or a combination thereof will interact with CWM software every day. As the category leader pursuing one of the largest available TAMs and software and coming off our record Q2 performance, we are confident in our approach and we'll maintain a forward-leaning investment posture to drive results for our customers, shareholders, and team. Now let me turn the call over to Pete to provide some additional detail on our financials. Pete?

Pete Godbole -- Chief Financial Officer

Thank you, Mark, and good afternoon, everyone. As Mark mentioned, Q2 was another strong quarter. Our Q2 outperformance relative to our guidance was a function of strong execution by our sales team, significant enterprise expansion, a record number of larger deals, and early success of our advance offerings. We have now surpassed pre-COVID levels across most aspects of our business.

I will now go through our financial results for Q2 unless otherwise stated all references to our expenses and operating results are on non-GAAP basis and are reconciled to our GAAP results in the earnings release and presentation that was posted before the call. As previously mentioned, second-quarter revenue came in at $131.7 million up 44% year over year. Subscription revenue with $121.1 million representing year-over-year growth of 45%. Our momentum is reflected by the sequential increase in subscription revenue of $13.1.

The highest quarterly sequential increase in the company's history. Services revenue was $10.6 million representing year-over-year growth of 40%. Turning to billings, second-quarter billings came in strong at $142.9 million representing year-over-year growth of 47%. Approximately 91% of our subscription billings were annual with 6% monthly.

Quarterly, semiannual, and multi-year billings represented over 3% of the total. Moving on to our reported metrics, the number of customers that ARR over $50,000 grew 64% year over year to 1,856. And the number of customers with ARR over $100,000 grew 73% year over year to 748. These customer segments now represent 50% and 36% respectively of total ARR.

Next, our domain average ACV grew 42% year-over-year to $5,915. We ended the quarter with a dollar-based net retention rate of 128%. A three percentage point improvement from Q1. The full churn rate dropped further and is now below 6%.

As a reminder in Q3, we will have the Brandfolder acquisition, which will result in a one to a two-point headwind on our dollar-based net retention rate. Inclusive of this headwind, we believe we will exit the year with a dollar-based net retention rate above 128%. Now turning back to the financials. Our total gross margin was 82%, two percentage points higher than the previous quarter.

Our Q2 subscription gross margin was 87%. Also two percentage points higher than the previous quarter. We continue to expect our gross margin for fiscal year '22 to be between 79% and 81%. Overall operating loss in the quarter was negative $5.2 million or 4% of revenue an improvement from 8% of revenue a year ago.

This margin improvement was a function of scale across, our sales and marketing, and R&D lines inherent in our model. Free cash flow is negative $3.5 million which overachieved against our guidance due to strong collections. Now let me move on to guidance. For the third quarter of fiscal year '22., we expect revenue to be in the range of $138 million, $139 million billings to be in the range of $149 million to $150 million, non-GAAP operating loss to be in the range of $15 to $12 million, and non-GAAP net loss per share to be between $0.12 and $0.10 based on weighted average shares outstanding of 126 million.

Our net free cash flow is expected to be in the range of negative $17 million to negative $15 million. Given our strong Q2 results and the continued momentum we see in our business, we are raising our full-year fiscal year '22 revenue and billings guidance. We now expect our revenue to be in the range of $530 million to $533 million representing a growth of 37% to 38%. Billings to be in the range of $619 million to $622 million representing a growth of 37% to 38%.

We expect the non-GAAP operating loss to be in the range of $55 to $45 million and non-GAAP net loss per share to be between $0.44 and $0.36 for the year based on approximately 125 million weighted average shares outstanding. Our free cash flow margin expectation in fiscal year '22 is to be between negative 6% and negative 4%. To conclude, we were pleased with this quarter on several fronts. Among them, the resonance of our dynamic work platform offering that is apparent by our early success with Advance.

Our billings outperformance, which indicates a strong demand environment in the quarter across segments and geographies. And enterprise traction evidenced by the record number of expansions greater than $100,000 and the sequential increase in customers with ARR of over $1 million. We see a big opportunity in front of us and are investing behind the signal. Now let me turn it back to the operator for questions.

Operator?

Questions & Answers:

Operator

[Operator instructions] And your first question is from the line of Brent Thill with Jefferies.

Brent Thill -- Jefferies -- Analyst

Good afternoon. Mark, just on large enterprise, I'm curious if you could spend a little time drilling in on the traction you're seeing. And also I know Pete mentioned that it's early on in Advance. What type of impact is that having? And then for Pete, I had a quick follow-up.

Mark Mader -- Chief Executive Officer

Hey, Brent. Yeah, it's really a combination of seeing growth on two dimensions. The first is on the seat dimension. People enrolling more people on the platform.

The second is elevating what they're doing with the platform. And I think Advance is giving people a really nice composite offering where they can do everything from scaling a certain process, implementing better import routines from the legacy systems. These are things that are I think fairly different than what I would say sort of transactional work management, which maybe sort of team task coordination and event planning. And I think what Advance is doing is giving people a much faster way to access the entire suite of offerings.

Brent Thill -- Jefferies -- Analyst

And for Pete, just 47% present billings down the low 30s on the guide, many will ask why such a sharp decel? Can you maybe just bridge what's happening in Q3 and I know there's some one-time emanate that's perhaps having some impact? Can you just make me walk through the decel? And why perhaps it's maybe not as severe as it looks?

Pete Godbole -- Chief Financial Officer

Sure, Brent, this is Pete. The comparison points on a quarter by quarter represent different economic realities. The comp in the first half is compared to a COVID impacted base and the second half represents a recovery starting to have a recovery from that base. That's one part of it.

The second part of it is, in the first half of fiscal year '21 we had no Brandfolder in the base. Now in terms of your specific question about Q3, if you recall in Q3 of fiscal year '21 we had a $4.7 million one-time acquired deferred revenue pickup, which when you sort of putting into our guidance that factored into our guidance would make our guidance about a 38% to a 39% year-on-year growth.

Brent Thill -- Jefferies -- Analyst

Great. Thank you.

Operator

And your next question is from the line of Mark Murphy with JPMorgan.

Unknown speaker

Oh, thank you very much. This is Benjalim on behalf of Mark. Congrats on the quarter guys. One question.

It has been a few quarters now since you launched Bridge. What has been the uptake of that product so far in terms of feedback? Are you seeing a lot of customers build a kind of cross-functional workflow automation such that Smartsheet is becoming more deeply embedded into the business processes? Is that part of the enterprise traction as well that you're seeing?

Mark Mader -- Chief Executive Officer

Yeah. Benjalim, it's -- you really have to think about it across all of our connectors not just Bridge. So it's a combination of Bridge, data shuttle, and then our purpose-built connectors. And those are included in our Advance offering.

And so with that availability of Bridge and those other connectors, we are seeing a significant increase in the number of workflows and the amount of data being transferred between Smartsheet and other systems of record. And importantly it's enabling us to connect to both other cloud or SaaS offerings, as well as a significant number of on-prem legacy systems. And so many of the solutions that we see out there today are over customers are pulling data from multiple sources into Smartsheet to manage work for a process. So we believe that definitely embeds us into the core workflow of the organization.

A really great example of that is we have a leading sportswear manufacturer that's actually using data shuttle to pull data into Smartsheet from multiple legacy systems to manage product lifecycle management of their sportswear offerings. And so it helps them manage inventory, logistics, and actually make better decisions about when to change out in the cycle out of products.

Unknown speaker

Understood. Just a double-quick a little bit the two expansions that you talked about over 1 million I think you said. Is that -- if you think about between seats and other offerings capability-based offering, how does that makes it look that $1 million sequential? Is that more driven by seats or more driven by some of these other products?

Pete Godbole -- Chief Financial Officer

I think we'll be notable two to speak to is that of our top 10 deals this quarter, seven of them contained Advance. So these are all hybrid deals where you have seat consumption as well as capabilities consumption. I think that's part of the best market to point to.

Unknown speaker

Understood. Thank you.

Operator

And your next question is from the line of Terry Tillman with Truist Securities.

Connor Passarella -- Truist Securities -- Analyst

Hey, guys. This is Connor Passarella on for Terry. Thanks for taking my questions and congrats on the quarter. I just wanted to go back and talk about the international, when we had quickly.

So one of the things that we were kind of curious about was you mentioned there was some different use cases between maybe the U.S. and international markets. What were those use cases you can maybe expand there?

Pete Godbole -- Chief Financial Officer

Connor, this is Pete. The use cases we see internationally are very consistent. There is the same kinds of use cases we see in the U.S. play out internationally as well.

We saw that the demand factor plays out as strong internationally as it was domestic.

Connor Passarella -- Truist Securities -- Analyst

Perfect. And then just one quick follow-up. So as you continue to land some bigger deals seven-figure and above. Are there any changes in linearity for forecasting in terms of these larger deals? And how should we think about those -- does going forward? Thank you.

Pete Godbole -- Chief Financial Officer

So I see we are closing a larger transaction that's a trend we've seen. What you should expect in the back half is as these transactions grow we'll start to see a larger weight for Q4 and you'll soon start to see an enterprise software seasonality play out.

Connor Passarella -- Truist Securities -- Analyst

Great. Thank you.

Operator

And your next question is from the line of Scott Berg with Needham.

John Godin -- Needham and Company -- Analyst

Everyone, this is John Godin on for Scott Berg. Appreciate you taking my questions and congrats on the quarter. Just curious given that the market is very much still in its early stages, coming out of the pandemic, are you guys starting to see customers seeking more to standardize one single solution versus having multiple CWM vendors? Any color there would be helpful. Thank you.

Mark Mader -- Chief Executive Officer

Yeah, we still see a huge opportunity which is -- which we consider greenfield. When we look at what we consider direct competitors in the category, we're talking very low teens, like 10%, 12% of our opportunities. We would consider a quote contested. So the vast majority are not.

So when we think about transactional use cases, there are so many teams and divisions within businesses that it's quite common in those scenarios where a team might choose a different solution. Where we see less sort of diversity is when it elevates within an organization and IT is asked to formally approve. So that would mean making sure that we have consistency in policy. Making sure that it's aligned with the authentication mechanisms of all those pieces.

That's where we are seeing IT make a decision for one. However, I would say those numbers of opportunities are still quite a few as people as the market is forming and we were talking low single-digit percentage of an available TAM that's been penetrated. We do expect that to change over time and one of the reasons we've invested so heavily in the enterprise dimension.

John Godin -- Needham and Company -- Analyst

Thank you guys very much.

Operator

And the next question is from the line of George Iwanyc with Oppenheimer.

George Iwanyc -- Oppenheimer & Co. Inc. -- Analyst

Thank you for taking my question. Mark, just start following up on those competitive answers that you just gave. Do you see very many head-to-head contested deals right now or is the majority of the opportunity is still greenfield like where are you displacing? What tools are you displacing?

Mark Mader -- Chief Executive Officer

I think as I said about roughly 10% of the deals you would hear of another competitor are not named sort of status quo. As you move up the ladder in terms of sophistication of what the customer is expecting, that number falls precipitously. So again if you look at four basic use cases, cash tracking, team coordination, you're going to see more players there. And as you move up whether it's on the dimension of combining work management with digital asset management, right, the Brandfolder Smartsheet combo, there's not a lot of options in the market for that.

So you see almost no competition there. And in terms of the companies that are being displaced, think of certain markets that are maybe considered legacy like the traditional PPM providers, the plan views of the world. I think there's a really neat opportunity to take a significant share in markets like that. And the team has done a great job of getting us ranked No.

1 in the PPM G2 ranking recently. So we see a really neat opportunity there to also to take share.

George Iwanyc -- Oppenheimer & Co. Inc. -- Analyst

OK. And then, the new customer generation continues to be pretty solid. How do you feel about that going forward? How are your partners contributing there? And do you expect the incremental leverage now that the Smartsheet Region is going to be available?

Gene Farrell -- Chief Strategy and Product Officer

Yeah, I think -- this is Gene. As we called out on the call we're seeing a nice uptick in partner contribution to overall ARR growth. And I think that we are absolutely looking at how we can support customers to land more often and discover what's possible as Smartsheet. And then as they learn what they're capable of graduate and move up to higher-level deployments and capabilities.

And so we think it's important to both continue to land pretty aggressively as well as drive the expansion motion. I think Regions will be a nice way for us to reach markets where data residency has been a concern for customers particularly when you look at markets like Germany where the regulatory environment makes it really challenging for local companies to host and manage all of their information in the United States. And so we see the launch of our first Region in Frankfurt as an unlock for us and there'll be more to come.

George Iwanyc -- Oppenheimer & Co. Inc. -- Analyst

Thank you.

Operator

And your next question is from the line of Keith Bachman with BMO.

Keith Bachman -- BMO Capital Markets -- Analyst

Hi. Thank you. I had two questions if I could. The first is, I want to try to understand how you're thinking about your longer-term profit targets including free cash flow which you've previously given.

How do you think about the path to realizing those targets have called a 20 plus percent margins at a time when both yourself and your competitor competitors are growing very fast? But none of which are generating positive free cash flow or are generating positive operating income. How do you think about the growth of trying to realize those targets? Or how should investors thinking about that? And then I have a follow-on if I could.

Pete Godbole -- Chief Financial Officer

Keith, this is Pete. Below the guidance, we gave him the total revenue was between fiscal year '23 and '25 we'd get to $1 billion of full-year revenue. We expect that to be in the back half of the year when we get to that we expect that to be FY '25.  So when we get to that number we believe our model is capable of generating free cash flow at scale. So that's kind of a statement we've made.

We think it's completely possible and to invest in the meantime as we get there. So we're sort of taking advantage of all the opportunities to invest and the huge standards ahead of us.

Keith Bachman -- BMO Capital Markets -- Analyst

OK. OK. Let me -- just my second question, though is your average ACV per customer is still growing very rapidly, 42% year over year and yet it still represents a relatively small percent of spend so to speak for your average client base. What are the main sources of friction that you see to keep growing that number over the next 12 months? And what are the main strategies and tactics that you're taking to keep growing that average ACV per customer if not accelerating?

Mark Mader -- Chief Executive Officer

Yeah. We -- we've grown I think north of 40% for quite a few quarters in a row now. I feel like we're feeling a lot of friction on that. With the Advance introduction really making it easier for customer understand for customers to understand what's available to them and then give them a very straightforward mechanism for engaging with us.

I think this is one of the reasons why I see a 158% growth rate on the over $100,000 deals. I mean it's landing with customers right now and we serve tens of thousands of organizations today. So our job is to really understand -- to make sure that our customers understand what their pathway is. And as we think about improving both the entry point into our platform as well as the presentation of the full suite, I think it's a lot on us to how do we really product market that extremely well.

But I think the ROI on some of these implementations is so high we're not seeing sort of challenge in terms of well we're not sure there's value here is more helping people understand how it coexists among their CRM investments, their ERP investments, and the other integration platforms that they have. So we're very pleased with the progress.

Keith Bachman -- BMO Capital Markets -- Analyst

OK. All right. Thank you.

Operator

And your next question is from the line of Arjun Bhatia with William Blair.

Arjun Bhatia -- William Blair -- Analyst

Yes. Thank you and congrats on the results. Mark one for you. I'd love to understand the role that Advance is playing in new customer acquisitions.

And if that's a part of the conversation at all with new customers it tends to be more of an expansion point as customers graduate from that transactional use case for the more transformational deployments that you talked about.

Mark Mader -- Chief Executive Officer

I think one of the really neat observations from the first quarter was that we had more Advance sales within our commercial quota-carrying rep group than we had in our large enterprise. So the message of Advance resonates all up and down the spectrum.  And what we're finding is as customers are assessing, which company to us go to market with they are and which to buy. They're saying what are my immediate needs. And then if I'm successful what is going to be asked of me in six months a year or two years out.

And I think the understanding of advancing the presentation of Advance not just from a capability standpoint, but from governance and an IT and security dimension that is something that's coming up more and more and more. So even if someone is not ready in the first month to say "OK I want to do a full control center data shuttle full integration with salesforce" it's important to them to know that. Because what they don't want to do is paint themselves into a corner and say oh my gosh we have tremendous success with 200 people and we're collaborating really well and then find out that they hit a roadblock with some type of IT requirement. So it is part of almost every one of our discussions now and we have enough confidence in the pathway to not have to force someone to do advance out of the gate, to say we've all quit -- since the beginning it's been around the earned enterprise.

You will sell someone what they need. You will educate them on what's available and then you will support them throughout that journey. And that is what we're now starting to see accelerate.

Arjun Bhatia -- William Blair -- Analyst

Wonderful. It's very helpful. And then Pete may be one for you. Just on the guidance, I think we saw an almost $20 million increase in both revenue and billings for the full year.

I don't know. I don't think we've seen that level of a raise before. Can you maybe just walk us through what you're seeing through August and the pipeline that gives you the confidence to raise guidance meaningfully.

Pete Godbole -- Chief Financial Officer

Arjun, as we've looked at the quarter we were really pleased to see some really strong demand signals emerge. The first one was on the transactional business which we consider sub-50, which came back to pre-COVID levels. It was in the number of transactions that came through as well as the cycle time to close those deals. So positive on that front.

The second thing we saw was the greater than 100 came to use which we consider large deals. Those two 158% year on year. So really strong momentum there as well. And then the last signal which was very meaningful to us was the first quarter out of the gate with our Advance pricing and packaging.

We saw that gain traction after being announced in June. We booked over 100 deals and it was in seven of our top 10 transactions. So that's the confidence that we are seeing as we build our guidance in revenue and billings that we shared with you.

Arjun Bhatia -- William Blair -- Analyst

Wonderful. Thank you very much

Operator

And your next question is from the line of Steve Enders with KeyBanc.

Steve Enders -- KeyBanc Capital Markets -- Analyst

Great. Thanks for taking the question here. I just want to touch a little bit more on the strength that you're seeing in the $100,000 deals and $1 million deals. I just want to get a sense for kind of what you think the biggest drivers are with them and with them that part of the market you think it's improve execution within your sales team? Or is there something fundamentally that's changed in the market for the past over the past year now that is helping to drive and support this?

Mark Mader -- Chief Executive Officer

I think what we're observing is when we thought about how we were going to orient or offering with Advance we always talked about customers, customers, customers how are they going to perceive it. How can they understand that? And then after talking about customers so much we said hey isn't the sales can be a huge benefit for our sales team. So if you're hiring upticking I think 30% more quota-carrying reps, the impact of having a more easily understood offering with value statements has a massive impact. And I think we're at the beginning of that and we are hiring very assertively throughout this year, but again that combination of both great for customers much better for that new onboarding sales rep as well.

And I would say again both on the commercial dimension and large enterprise.

Steve Enders -- KeyBanc Capital Markets -- Analyst

That's great to hear and just a follow-up on that. Yeah. Good to hear that. The continued sales execution in hires there, but how are we thinking about the channel opportunity and hope in having that augment that go to market motion.

And how is the channel I guess kind of changing the types of customers the opportunities that you're bringing in here now?

Mark Mader -- Chief Executive Officer

What we're recognizing is that the channel is not just about who brings leads to you. It's about who can also provide expertise in certain areas and solutions that you're trying to solve for. So if you have someone who's steeped in manufacturing, steeped in healthcare, steeped in technology best practices those can be superadditive to your sales business. So when we talk about the 93% year-on-year increase it is both a combination of people bringing us deals and also assisting on deals.

So I think that that hybrid go-to-market of Smartsheet team combined with partnering field who's the trusted source already, we see that is actually a very significant portion of that what we call the channel business.

Steve Enders -- KeyBanc Capital Markets -- Analyst

OK. Perfect. Thanks for taking my questions.

Operator

And your next question is from the line of Michael Turrin with Wells Fargo.

Michael Berg -- Wells Fargo Securities -- Analyst

Hey. This is Michael Berg on for Michael Turrin. I want to kind of piggyback in from the last few questions on the success in the large enterprises. When you think about both the impact of the channel, as well as Advance how can we quantify? Maybe the increase in ACV for some of those other partner deals or deals with Advance.

Obviously, there's a seven of the 10 largest transactions in the quarter a metric. So just kind of curious how to put some more color around that.

Mark Mader -- Chief Executive Officer

I think when we look at Advance, it's a driver of -- it's a sign that somebody is making a more substantive advance investment in the platform. We do expect that all Advance transactions will be north of 5 k. Right? So everything that you have is going to be accretive to that measure. In terms of when partners are involved.

I think partners are often very well suited to have larger solution discussions. They may know the business more deeply they may know what that business is looking to solve for which I think lends itself really well to a more again substantive solution that they're better presenting. Very often those larger solution recommendations require the strength and the platform that advance better back to offers. I would say if you're looking to sell a very significant solution it's probably going to be more than seats.

It's one of the key indicators that we see when somebody is really looking to do something again beyond that transactional work management work. Yeah, I think in terms of -- I think it's. I think we will we will keep it there in terms of additional texture, but again we're very pleased to see that the growth will continue to be shaped by just flat-out usage and then also the suite offering that we've been speaking about.

Michael Berg -- Wells Fargo Securities -- Analyst

Very helpful. Thank you very much. And a quick follow-up. When you think about your business longer-term, obviously you've stated the sizable TAM, but with lots of greenfield.

Well, I think technologically speaking we keep hearing RPAs coming into workflow automation type use cases. How can you talk about your platform and either using RPA or coming up against that eventually competitively and just dramatically as it pertains to the Smartsheet business?

Gene Farrell -- Chief Strategy and Product Officer

Yeah. Hi, Michael, this is Gene and I would say that today we really see RPA as being a complement to where we are. I mean, RPA vendors are moving beyond just trying to automate kind of rote process and starting to move more into orchestration. And you saw us I think last quarter we announced our integration with UIPath.

And we're seeing the ability to engage with customers, as they think about their whole software suite and really think about what are the workflows that maybe will originate in RPA and then move over into Smartsheet to engage with their teams. And it's really not an either-or it's really a both from what we've seen. And I think that's part of why we're building bridges there and alliances because we hear that signal from customers that it's being part of that strategic software stack really requires you to be able to interact with RPA and the other big systems of record, whether it be ERP or your HR systems. And so that's what we're building for.

Mark Mader -- Chief Executive Officer

If I could add one piece is I think one of the hallmarks of our category also is it provides the interface. It's not the platform that it's only the platform that processes. It's the interface that people configure and actually utilize to update that information and trigger events. That interface takes years and years to develop and tuned to get aligned with the user preference.

And I think that's one thing that will we'll keep our category very relevant as people are looking to solve.

Operator

And your next question is from the line of Rishi Jaluria with RBC.

Rishi Jaluria -- RBC Capital Markets -- Analyst

Wonderful. Thanks so much for taking my questions guys. Nice to see continued improvement here. But first I'd like to actually start exactly on that.

So by all metrics business continues to improve. I just want to get a sense of how much of the acceleration and improvement in the underlying metrics so far? Is it just recovery and some of the headwinds fading that we saw during a pandemic, SMB coming back versus factors, longer-term secular tailwind,  things like work turning more being more high returning more asynchronous in nature? Have those tailwinds started to show up in the business or have those you really get to play out? And then I've got a follow-up.

Mark Mader -- Chief Executive Officer

That really -- I really feel like we've surpassed where we were heading into code and it's really refreshing to see an offering has changed, right? I think people's fluency around what they need and what is possible has fundamentally changed over the last 18 months. So this is not about getting back to where they were. This is I think people are in a much stronger position today to make informed calls. Pete, anything to add.

Pete Godbole -- Chief Financial Officer

I think what I would say is we're starting to see that recovery go beyond where we were in COVID times. And you can see that in the metrics whether it's the transactional volumes whether you see that in the cycle times you're seeing that in spades. So I think you're starting to see that and I think as it relates to the obvious systemic beneficiary of it, I think that's a longer-term question. But clearly, over the last 12 or 18 months, the fluency with the space has gone up and you're seeing that in transactional volumes.

Rishi Jaluria -- RBC Capital Markets -- Analyst

OK. Great, that's helpful. And then Pete for you on on the billing side it looks like there was a big uptick specifically in the mix of billings that are annual kind of actually higher than even it was pre-COVID. During the pandemic, there was some talk of customers wanting to go to shorter duration deals right go monthly versus the annual deals.

Can you talk a little bit more about that mix and are you seeing more willingness to sign upfront annual deals versus that monthly? Or what's going on there and how should we be thinking about the billings mix going forward? Thanks.

Pete Godbole -- Chief Financial Officer

I think, Rishi, the -- if you looked at the mix had in the thick of the pandemic, we saw a little bit more from the monthly sort of plans we saw in place. But since then we've been probably consistent in the amount of our new plans. It might vary a little bit by 1% plus or minus. And that's kind of the trend we're seeing.

Rishi Jaluria -- RBC Capital Markets -- Analyst

OK. Wonderful. Thank you so much, guys.

Operator

And your next question is from the line of Tyler Radke with Citi.

Tyler Radke -- Citi -- Analyst

Hey. Good afternoon thanks for taking my question. You talked a lot about data residency this call and I just really wanted to expand on that topic a little bit. Just give us a sense for how significant of a breakthrough that capability was and maybe why it wasn't released earlier? Just give us a sense for maybe some pent-up demand that you could see internationally from rolling this feature out.

Gene Farrell -- Chief Strategy and Product Officer

Yeah, Tyler this is Gene. That the real unlock for us in data residency was the transition we completed last year to the public cloud. We really needed to move our infrastructure into the public cloud to enable the ability to extend to different regions around the world. And so the first region in the area where we've seen the most customer interest has been in the EU and specifically, residency requirements in Germany.

And that really became an unlock for us after we completed that cloud transition. We do hear significant customer feedback around the need to have a local resident. They are having their Smartsheet data being in the country for a broad set of use cases. And it doesn't mean that we don't get adoption in the EU today, but we definitely believe there will be a lot less friction once we have that unlock.

And in Germany in particular there are a number of data regulations that prevent certain types of data to be stored outside of the country. You have a similar scenario in EMEA, Australia, for example, any government customers have a requirement that all of their data be in residence as well or in-country as well. And so we see it as a natural extension. And as in the coming quarters while more to talk about the things we're doing to expand our footprint and grow internationally.

And we believe Smartsheet Regions are going to be a key contributor to that strategy.

Tyler Radke -- Citi -- Analyst

Great. And I guess a follow-up just on the guidance. Certainly. Most metrics revenue billings were raised, but I look at operating income you outperformed by over $10 million in the quarter relative to your guide.

But despite the raise and revenue looks like you're keeping your full-year operating guide the same. So I was just curious about timing-related, I think most companies we've seen just in terms of the budget for any returning and returned to offices take to get pushed out. But just any color on kind of where that incremental spend is coming from. Thank you.

Pete Godbole -- Chief Financial Officer

So we're investing aggressively in an opportunity we see ahead of us. So all the over performance or deltas we apply into investment capital and that's been the thesis so far of how we've operated. That's kind of what you're seeing across the board we are committed to the $55 million to $45 million in op income that we've guided to, and we're investing the delta.

Mark Mader -- Chief Executive Officer

The negative.

Pete Godbole -- Chief Financial Officer

The negative.

Tyler Radke -- Citi -- Analyst

Thank you.

Operator

[Operator instructions] And your next question is from the line of Allan Verkhovski with Wolfe Research.

Allan Verkhovski -- Wolfe Research -- Analyst

Hey there. Thanks for taking my question. I want to ask how is the linearity in the quarter? How does it compare to prior periods as well in terms of how the pipeline progressed? Is there anything that thinks there that could be exciting from an upside perspective, such as federal activity going forward? And I've got a quick follow.

Pete Godbole -- Chief Financial Officer

To the linearity we saw in the quarter was very consistent with the previous quarter. So no real change there. I think in general we were pleased with how the pipeline converted both in quarter generated pipeline as well as pipeline before the start of the quarter. We had similar metrics across regions and segments and seemed very consistent.

Allan Verkhovski -- Wolfe Research -- Analyst

Got it. And you'd also mentioned that gross churn is getting better. Could you talk about what is necessarily driving that? Is that a result of the market? Or what you're pursuing and how much better can it get? Thank you.

Pete Godbole -- Chief Financial Officer

So we saw gross churn improve in the prepared remarks we said it dropped below 6%. I think we're seeing two elements drive that. The first one is a year ago we were hearing a lot more about COVID. The number of mentions in COVID in all our accounts has gone down significantly, which is the first item.

And then the second item is, we're seeing that our platform the new UI we launched is very engaging and that customers are really resonating with what the UI does for them. And we believe that's a contributor to seeing a lower level of churn.

Operator

And there are no further questions. Mr. Turner, do you have any closing remarks, sir?

Aaron Turner -- Head of Investor Relations

Great. Thanks, Tabitha. Thank you, everyone, for joining us today, and we will speak with you again next quarter.

Operator

[Operator signoff]

Duration: 51 minutes

Call participants:

Aaron Turner -- Head of Investor Relations

Mark Mader -- Chief Executive Officer

Pete Godbole -- Chief Financial Officer

Brent Thill -- Jefferies -- Analyst

Unknown speaker

Connor Passarella -- Truist Securities -- Analyst

John Godin -- Needham and Company -- Analyst

George Iwanyc -- Oppenheimer & Co. Inc. -- Analyst

Gene Farrell -- Chief Strategy and Product Officer

Keith Bachman -- BMO Capital Markets -- Analyst

Arjun Bhatia -- William Blair -- Analyst

Steve Enders -- KeyBanc Capital Markets -- Analyst

Michael Berg -- Wells Fargo Securities -- Analyst

Rishi Jaluria -- RBC Capital Markets -- Analyst

Tyler Radke -- Citi -- Analyst

Allan Verkhovski -- Wolfe Research -- Analyst

More SMAR analysis

All earnings call transcripts