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

  • New Report features on a Dashboard
    In Formulas and Functions
    Hello everyone, happy Friday, So a colleague of mine reached out for some support on creating dashboards. Our organization recently switched from the Google sheets platform to Smartsheets, so there is a solid skill gap amongst us all. So …
    Answered - Pending Review
    18 2
    Answered - Pending Review 18 views 2 comments Most recent by Andrée Starå
  • Attachment alerts
    In Formulas and Functions
    Dears, Would it be possible to set up an alert when CERTAIN USERS UPLOAD DOCUMENTS? In this case we would need to be notified when our customer - only our customer uploads documents. We upload documents as well but we do not want to get n…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå
  • SUMIF Partial Text
    In Formulas and Functions
    I'm trying to sum the contract amount if the contract status contains Awarded. Contract Status is a multi-select column so may contain more than one status. =SUMIF({Contract Status}, CONTAINS(@cell, "Awarded", {Contract Amount…
    Accepted
    18 2
    Accepted Answer 18 views 2 comments Most recent by Genevieve P
  • Multiple IF + IF(NOT
    In Formulas and Functions
    Hello and happy New Years to everyone, I am a little stuck on a formula and would need your help. Here is my formula: =IF([Column2]@row = "France", IF([Primary Column]@row = "Value 1", "Value A", IF([Primary …
    Accepted
    17 3
    Accepted Answer 17 views 3 comments Most recent by Bassam.M Khalil
  • Which children have status completed in the last week?
    In Formulas and Functions
    I have a smartsheet tracking development of a new product and I want to put in the summary sheet how many units have been completed in the past week. How do I do that using the children function? Thanks!
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Mark Cronk
  • Help on IF Formula - Multiple Statements
    In Formulas and Functions
    Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, &qu…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Mark Cronk
  • Nested criteria
    In Formulas and Functions
    I have this formula but it comes back with a "nested criteria" error message: COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approve…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Mark Cronk
  • Why isn't MAX returning the most recent DATE?
    In Formulas and Functions
    Hi All, I'm trying to use MAX to show the most recent date in column that's "Auto-number/System - Modified (Date)", but frustratingly it's not always correct. Anyone have any idea as to why? And more importantly, how to fix?
    Accepted
    14 3
    Accepted Answer 14 views 3 comments Most recent by Mark Cronk
  • IF-WORKDAYS Calculation
    In Formulas and Functions
    I have a sheet with a [Request Submitted] column. Our SLA to attend to any received request is 2 business days. So I'd like to add a column that highlights any overdue items. My logic is: If TODAY is 2 business days past [Request Submit…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Mark Cronk
  • Accepted Answer 25 views 8 comments Most recent by Cathy Wagner