Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Announcing Several Formula Enhancements Available Now
    In Formulas and Functions
    Hi Community,  One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faster, but can help you reclaim time throug…
    420 5
    Announcement 420 views 5 comments Most recent by Andrée Starå
  • Copy parent row only
    In Formulas and Functions
    I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., …
    Answered - Pending Review
    16 5
    Answered - Pending Review 16 views 5 comments Most recent by John DeRoy
  • Symbols Color Change based on Dates
    In Formulas and Functions
    Hello, I'm looking for a formula that will automatically change based on close we are to the due date. So let's say the following: 30 days till the live date, Green 15 days till the live date, Blue 5 days till the live date, Yellow under…
    20 6
    Accepted Answer 20 views 6 comments Most recent by Andrée Starå
  • Sales Projections Sheet
    In Formulas and Functions
    Hello All: I'm working on a sales projections sheet and looking to create and easy to notice symbol, on target, below target, and off-target. What is the formula to be able to easily create this? Thanks in advance. MH
    15 3
    Accepted Answer 15 views 3 comments Most recent by Andrée Starå
  • How to deconcatinate
    In Formulas and Functions
    I need to be able to separate out the five sections separated by commas into five adjacent blank columns ED Class, Wednesday, 01/20/21, 9:00 am - 12:30 pm, Happy Hospital Thanks, Laura
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by laura.buchanan
  • Cross-sheet COUNTIFS with three parameters.
    In Formulas and Functions
    Inside a current sheet I can do a COUNTIFS with 3 parameters. I do not seem to be able to do that if I am referencing another sheet. It appears the limit is 2. Is this correct or am I missing something?
    Answered - Pending Review
    91 6
    Answered - Pending Review 91 views 6 comments Most recent by KDM
  • How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66
    In Formulas and Functions
    I'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute…
    16 0
    Question 16 views 0 comments Started by Tshaw
  • Automatic Workflow for multiple rows
    In Formulas and Functions
    Hi there , I would like to learn that , when we crreate an automatic workflow system taking action based on one row , i want that at the same time system will take action for all the rows with one alert. For example imagine that , there ar…
    15 10
    Accepted Answer 15 views 10 comments Most recent by Erhan_79
  • Need help with syntax for IF(AND(OR nested statements for a risk assessment table
    In Formulas and Functions
    this is what I have, getting an unparseable error. I changed all the "" to straight quotes. trying to make the cell this formula is in, equal a risk rating as determined by the formula, the graphic matrix is below. HELP!! =IF(…
    Answered - Pending Review
    25 4
    Answered - Pending Review 25 views 4 comments Most recent by Robert Charles
  • formula that when completed next start date is +330 days
    In Formulas and Functions
    I am trying to figure a formula that when I actually complete something, that the start date row will trigger the next time it needs to be done. Example: I have start date, due date, and actual complete date. Start date would be 2/1/21, wi…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Andrée Starå
  • Using Smartsheet for Knowledge Management
    In Formulas and Functions
    Does anyone use Smartsheet for Knowledge Management? I'm thinking of utilizing Smartsheet for this purpose ("How To" videos, templates for employees to use, ect). I was wondering if anyone uses if for a similar purpose if you cou…
    Answered - Pending Review
    18 1
    Answered - Pending Review 18 views 1 comment Most recent by Bassam.M Khalil