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

  • Index Question
    In Formulas and Functions
    I have two smartsheets. One contains my budget and one contains budget vs actual. Currently, Im using an index function to find the budget for the month of each cost account BUT every month I have to go update the column index in the funct…
    Answered - Pending Review
    15 6
    Answered - Pending Review 15 views 6 comments Most recent by Cristina Andersen
  • Shorten numbers & format to display thousands as "K" , millions as"M" but still remain as numbers
    In Formulas and Functions
    Hello everyone, Good day. I'd like to ask your help regarding a task I'm trying to complete on Smartsheet. I'm trying to shorten the numbers in a table show thousands with "K" and millions with "M" after the first comma…
    Answered - Pending Review
    23 2
    Answered - Pending Review 23 views 2 comments Most recent by Peter Hui
  • Cells with a formula date calculation are changing automatically...help!!
    In Formulas and Functions
    Hello all - I'm throwing this out there as it's completely stumped us and I'm hoping this has happened to someone else and they know what's going on! We have a sheet that we have formulas created to calculate a backward scheduled start a…
    Unresolved
    36 4
    Question 36 views 4 comments Most recent by Mark Cronk
  • Dashboard - showing tasks/projects for a particular month or product
    In Formulas and Functions
    I have sheet which has a column shows upcoming improvements (projects) to products, another multi-select column which states which products are affected, and then another column for the target release month of that improvement. Is it possi…
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by Tash Dawson
  • Index Match - Multiple Criteria Referenced From Another Sheet
    In Formulas and Functions
    I am building an employee lookup sheet. This sheet is referencing a sheet that is populated from an excel spreadsheet that HR runs. They will update this sheet monthly. The sheet has managers, area managers, district managers, AVPs, etc. S…
    Accepted
    18 3
    Accepted Answer 18 views 3 comments Most recent by Mark Cronk
  • Split a number using LEFT and Right Formulas
    In Formulas and Functions
    I have a location number that is 6 digits long. I am trying to create a formula using LEFT and Right to add a dash after the first 4 numbers. EX: if the location number is 123456, I want to create a formula to show 1234-56
    Accepted
    14 3
    Accepted Answer 14 views 3 comments Most recent by Mark Cronk
  • Help with a week formula
    In Formulas and Functions
    Hi, I need assistance in creating a formula in which it tells me what week we are into the month, so every month on the first it must start at week 1 and then every Monday thereafter it needs to go to the next week please? Regards Rainier
    Answered - Pending Review
    11 5
    Answered - Pending Review 11 views 5 comments Most recent by Rainier Hollands
  • Here I have data and My task is to apply filter
    In Formulas and Functions
    Please have a look and help me with this, Here I have data and i My task is to apply filter EX: I need data which is < 0.7 (Virat has four allocated categories if i add all of them will get sum as 1.7 ) and dhawan is @ 0.9... i need a f…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Andrée Starå
  • AVG(COLLECT) issues
    In Formulas and Functions
    This discussion was created from comments split from: Averageifs Question.
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by David Joyeuse
  • Trying to use a IF(AND formula
    In Formulas and Functions
    This discussion was created from comments split from: If Function between different sheets.
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by David Joyeuse