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

  • Symbol formula question
    In Formulas and Functions
    Hello! I'm looking for a formula which has the following rules... There is a sheet with a due date column, a date begun column, a % complete column (manual entry), and an Urgency column which will be the symbols with the formula. If you ar…
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Paul Newcome
  • Vlookup to find result in child row
    In Formulas and Functions
    Hi all I am after help on a formula to pull in information from another smartsheet using vlookup but at the child level. I am looking for a match in my project to Ref, which is 699 and then find the data within the child row from Task 01. …
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome
  • SUMIF spend total by year
    In Formulas and Functions
    Hey guys, I have been trying to write a formula which allows me to calculate the amount of spend by year but cannot figure out what i am doing wrong. I tried the following: =SUMIF(Debit5:Debit339, [Spend date]5:[Spend date]339, >=1 / 1 …
    Answered - Pending Review
    8 2
    Answered - Pending Review 8 views 2 comments Most recent by Toni Francis-Kearns
  • Calendar View in a Report
    In Formulas and Functions
    I have our main schedule linked out to a report so we can filter each locations calendar. On the computer I can view everything correctly when I filter out certain locations. However, on the mobile app only a few of the events will popul…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå
  • Two Levels up PARENT formula
    In Formulas and Functions
    HI THERE! Would like to ask if there is a formula that allow us to access the parent row but always the level 2 hierarchy. Normally, PARENT() solves the inmmediate parent only. Much appreciated.
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå
  • Using smartsheet to book workspaces/meeting rooms
    In Formulas and Functions
    Hi there, I am looking to build some sort of process so that staff can book an allocated workspace as we start to return to working in the office post covid-19. Currently staff are requesting access to the office through a form in smartsh…
    Accepted
    264 17
    Accepted Answer 264 views 17 comments Most recent by Marilyn Morikang
  • Editing multiple update requests
    In Formulas and Functions
    Is there a way to filter/sort by rows with pending update requests or even mass delete all pending requests? Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automati…
    Accepted
    81 2
    Accepted Answer 81 views 2 comments Most recent by Lauren La'Brooy
  • Max Function but with Text
    In Formulas and Functions
    Hello Smartsheet Community: I want the Overall column to look at Issue A, Issue B, Issue C and Issue D and return the highest level. The levels are No Deficiencies, Low, Medium and High. Is that possible with text? See screen shot. I know…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Mark Cronk
  • Joining cells of multiple columns into one cell
    In Formulas and Functions
    I would like to gather the row responses in the columns outlined in red into the column outlined in green so that I can display just one column in a report instead of several. I have the following format I am starting from. It works well f…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Mark Cronk
  • JOIN/COLLECT when referencing a Dropdown (Multi Select)
    In Formulas and Functions
    I am trying to use a conditional IF based JOIN/COLLECT to generate a phrase in another column for notification purposes, but the column that the JOIN/COLLECT is referencing is a multi-select column and I can’t figure out a way to join mult…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Mark Cronk