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

  • Update Requests - Displaying (via Reports or Dashboard)
    In Formulas and Functions
    Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could bui…
    Answered - Pending Review
    17 8
    Answered - Pending Review 17 views 8 comments Most recent by Mike Rini
  • How do I extract dateonly from system generated date columns?
    In Formulas and Functions
    Hello, I would like to create conditional formatting based on a system-generated date being more than 7 days in the past (my test is if it's less than 6, then trigger the flag). I created a helper column to do the math, upon which the cond…
    Accepted
    25 13
    Accepted Answer 25 views 13 comments Most recent by Paul Newcome
  • Replace data in cells of moved row for formula of cells above in destination sheet
    In Formulas and Functions
    I've created an automation for moving a row to another sheet. After moving I want in some cells that the original data that came from the source sheet will be replaced for a formula as in the above rows of the destination sheet. Until now …
    Answered - Pending Review
    14 4
    Answered - Pending Review 14 views 4 comments Most recent by Mark Berg
  • Formula to add incoming inventory to existing inventory?
    In Formulas and Functions
    Hello, I am trying to figure out a formula for my inventory sheet. I am trying to create an automatic formula that when a shipment is marked received, it will update the inventory sheet. I thought it would look like =SUMIFS({Customer Orde…
    Unanswered
    4 0
    Question 4 views 0 comments Started by Devon Spencer
  • Calculations with dates
    In Formulas and Functions
    I need help figuring out date calculations. I've tried many different things and nothing works so far. I have a list of projects, each project has a list of tasks with start and due dates. I need to calculate the difference between the st…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Melisa Dannhauser
  • Ignore blank Cells
    In Formulas and Functions
    Hi I'm trying to get the following formula to ignore blank cells =INDEX(([1]:[1]), MATCH(MAX(Created:Created), Created:Created, 0)) Can't quite get it to work.
    Unanswered
    8 0
    Question 8 views 0 comments Started by Steven Griffiths
  • nested if formatting
    In Formulas and Functions
    Hi, Could you please share a proper format of a nested if statement? getting UNPARSEABLE error: =IF([% Complete]@row <= 0.7, "Red", IF([% Complete]@row > 0.7, AND,[% Complete]@row < 1,"Yellow"),IF[% Complete]@…
    Accepted
    18 2
    Accepted Answer 18 views 2 comments Most recent by Larissa Avtenieva
  • RYG health and status indicator roll-up
    In Formulas and Functions
    (Image) I currently have something similar like this setup for a number of projects, for each of the deliverables, I use the following formula: =IF(Status4 = "Complete", "Blue", IF(Status4 = "At Risk", "…
    Answered - Pending Review
    36 9
    Answered - Pending Review 36 views 9 comments Most recent by Andrée Starå
  • Struggling with SUMIFS
    In Formulas and Functions
    Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, whe…
    Answered - Pending Review
    5 7
    Answered - Pending Review 5 views 7 comments Most recent by Andrée Starå
  • Scanning QR codes
    In Formulas and Functions
    Hello everybody! Ive got a QR code that has 3 lines of text, and when scanning it, they are merged into one string w/o spaces. Is there somehow I can scan the code, so that the 3 lines are put into 3 different columns instead of them being…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå