Skip to main content
  • Smartsheet
        • Product Overview
          Manage projects, automate workflows, and build solutions at scale with Smartsheet. Learn more
      • Features
        • AI
        • Automation
        • Team collaboration
        • Dashboards and reporting
        • Account administration
        • Integrations
        • Digital asset management
        • Resource planning
        • Portfolio management
        • Secure request management
        • Intelligent workflows
        • No code work apps
        • See all features
        • Discover our latest product updates and enhancements
          Quarterly Disclosure Global Nav Graphic
        • Advanced Work Management Scale, connect, and empower your business for the future. Explore our offering
        • Professional services Information about Smartsheet consulting, training, and implementation support. Available services
        • Trust and security A complete summary of Smartsheet security and reliability. Trust Center
        • Watch a demo
        • Start a trial
      • Featured
        • Projects and Portfolios
          Modern Project and Portfolio Management
          Explore
        • Operations Management
          Strategic Transformation
          Explore
        • Digital and IT Portfolio Management
          Explore
        • Client and Partner Delivery
          Explore
      • By use case
        • Project management
        • IT Portfolio management
        • Business PMO
        • Enterprise PMO
        • Marketing management
        • Creative operations
        • Services delivery
      • By Industry
        • Government
        • Construction
        • Financial services
        • Higher education
        • Nonprofit
        • Enterprise
        • Small and medium business
      • View all solutions
        • Template gallery Streamline your work with the perfect template for your team. See all templates
        • Customer stories Behind the scenes with organizations around the world using Smartsheet to do incredible things. See all stories
        • Experience the future of productivity with Smartsheet AI
          Smartsheet AI
        • A 3x Leader in the 2025 Gartner® Magic Quadrant™ for CWM
        • Watch a demo
        • Start a trial
        • Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform. Explore the Content Center
        • Managing work
        • Product updates and insights
        • Inside Smartsheet
        • Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet. Get started
        • Smartsheet University
        • Knowledge base
        • Training options
        • Support
        • Professional services
        • Partners An overview of the Smartsheet Partner Program, including program details and a directory of global partners offering expertise and solutions. Learn more
        • Find a partner
        • Become a partner
        • Partner solutions
        • ENGAGE
          Engage Header Nav Graphic
          Join customers, experts, and partners to explore success stories, swap insights, and learn how Smartsheet turns ideas into action. Learn more
        • Smartsheet events
          Smartsheet staff standing and talking at ENGAGE
          Your hub for Smartsheet events, webinars, Q&As, and user groups.
        • Community
          Explore user-generated content and stay updated on our product features.
        • Watch a demo
        • Start a trial
    • Pricing
    • Contact
    • Select language
    • Log in
      • Start a trial
      • Watch a demo
    • Watch a demo
    • Try Smartsheet for free
    • Select language
    • Open search
    • Log in
Breadcrumb
  1. Content Center
  2. Product Release News

Article

24 new formulas added

PM

Product Marketing

24 new formulas added

July 2, 2019

These highly requested formulas significantly improve user productivity and include CONTAINS, DISTINCT, AVERAGEIF, and DESCENDANTS. To see all of the new formulas in action, check out the Smartsheet Formulas Examples sheet

  • Smartsheet
    Smartsheet logo
    • Product
      • Overview
      • Solutions
      • Features
      • Integrations
      • Pricing & plans
      • Advanced Work Management
      • Professional services
      • Trust Center
      • Template Gallery
      • Why Smartsheet
      • Start a trial
      • View pricing and plans
    • Resources
      • Content Center
      • Product insights
      • Help and Learning
      • Smartsheet University
      • Training options
      • Support
      • Community
      • Partner program
      • Release updates
      • Developers & API
      • Watch a demo
    • Company
      • About us
      • Leadership
      • Newsroom
      • Customer stories
      • Careers We're hiring!
      • Privacy
      • Legal
      • Contact us
    • Learn
      • Project management templates
      • Smartsheet dashboard gallery
      • 5 steps for getting started with the Smartsheet API
      • 3 formulas to look up data in Smartsheet
      • Unlock the power of Smartsheet with AI
        Smartsheet AI
      • Learn more about ENGAGE
        Engage Footer Nav Graphic
Download desktop app
  • Facebook
  • X
  • LinkedIn
  • TikTok
  • YouTube
  • Instagram

©2026. All Rights Reserved Smartsheet Inc.

 •

Machine Translation Disclaimer

 •

Cookie Preferences

 •

Your Privacy Choices
Download on the Apple App Store Get it on Google Play