Formulas

Using IF, Index, Match
Hello, I need a formula that will create the response "Green" if the Agency name matches the "Live Agencies" sheet to my current sheet, as well as have any of the following services (485 Review, OASIS/485 Review (No coding), or Non-OASIS 485 Review) in the "Coding Services" column of the "Live Agencies" sheet and create…
Dynamic formula to update a cell with a URL & Display Text
When I create a URL in a cell, it consists of the URL, and Display Text. How do I write a formula to, say, add the value from the autonumber field onto the end of the URL, and then display the autonumber field text as the Display Text?
Nonparseable error using IFError
this formula keeps an error. =IFERROR(INDEX(DISTINCT({Project Info PM}), ROW()), "")
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
Merged: Allow single cell references to be converting to column formulas
This discussion has been merged.
Merged: Allow a column formula to be from a fixed cell
This discussion has been merged.
Merged: Allow $ (absolute references) in Column Formulas
This discussion has been merged.
Merged: Ability to remove a column formula from individual cells for manual updates
This discussion has been merged.
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
Mastersheet Linking errors after adding column #unparseable #incorrect argument #blocking
I added a new column to a target sheet. Broke my mastersheet, resulted in #incorrect argument error in all columns with the exception of Primary Column. Went thru checking all column types basic trouble shooting of links couldn't resolve it. I made a new Mastersheet opened "table view", use formula cell linking. Created 4…

Upcoming Events

Smartsheet System Admin Essentials
Join our Smartsheet System Admin Essentials webinar to learn how to manage your organization's Smartsheet environment! This session is designed specifically for Smartsheet System Admins. We'll walk you through the core responsibilities of a System Admin and show you how to confidently navigate the Admin Center. After the…
Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。
Managing your Smartsheet Subscription: System Admin Workshop
Join us for one of our upcoming live sessions to learn about Smartsheet seat management. These events are designed to help you, Smartsheet System Administrators, stay ahead in efficiently managing your organization's Smartsheet users. In these sessions, we'll explore: • Effective navigation of the Smartsheet Admin Center •…

Formulas

Discussion List