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

  • How i can add a other currency like THB (Thai Baht), Currencys which are not listed?
    In Formulas and Functions
    Hello Community, I would like to add other currency, THB Thai Baht, Currencys which are not listed? Thx in advance S.Carlo
    Accepted
    8 3
    Accepted Answer 8 views 3 comments Most recent by Andrée Starå
  • Join Function Not Working As Expected
    In Formulas and Functions
    When I join across cells it is taking the last option from the Core Column and the first option in the Calyx Column and combining the text. Any suggestions will be helpful. The formula I am using is =JOIN(Core1:Calyx1, " ") (Imag…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Genevieve P
  • Can IF, Contains and VLOOKUP be combined?
    In Formulas and Functions
    Hi all, I am trying to combine IF and CONTAINS with VLOOKUP (refer following) but it is throwing #INCORRECT ARGUMENT =IF(CONTAINS("1", {Count}, VLOOKUP("TD", {Mastersheetrng}, 2))) Can these be combined, or some other c…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Genevieve P
  • A Single Formula to SUM a variable range of cells in a row
    In Formulas and Functions
    Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum …
    Accepted
    15 7
    Accepted Answer 15 views 7 comments Most recent by Andrée Starå
  • Formula renumbers when row added - I don't want it to.
    In Formulas and Functions
    I have a formula that populates the Asset # =IF(COUNT(ANCESTORS([Deliverables and Tasks]@row)) = 2, ([email protected]) + 10 + COUNT(DISTINCT([Asset #]$1:[Asset #]6)), PARENT()) This generates MA100, MA101, etc. where each Ancestor = 2 (basical…
    Unanswered
    19 0
    Question 19 views 0 comments Started by Jeana
  • Formula needed for IF function
    In Formulas and Functions
    I need a formula to say if a certain cell's number is less than 1, then another cell equals 135, and if that same cell's range 1-2, then another cell equals 225, and so on. My ranges are: <1 = $135 1-2 = $225 2-9 = $90 10-19 = $72 20-2…
    13 views 1 comment Most recent by Genevieve P
  • Calculate % on time deliveries for team
    In Formulas and Functions
    Hi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC"…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Genevieve P
  • Task Dependency
    In Formulas and Functions
    Hi Team , As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task…
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by Jameel Nahas
  • Report from 2 sheets shows same column header twice and doesn't combine
    In Formulas and Functions
    I have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it doesn't do this with an…
    Accepted
    15 4
    Accepted Answer 15 views 4 comments Most recent by Madyson Morris
  • How to capture a value from multi-select column
    In Formulas and Functions
    Which formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection…
    Accepted
    22 6
    Accepted Answer 22 views 6 comments Most recent by ameyaa