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

  • Automation: Trigger "Update Request" when changes are made by specific person
    In Formulas and Functions
    Hi, Is it possible to send an automated update request to a specified person(i.e. person A) when values in the data sheet is changed by another person (i.e. person B) ? Different users may change the values in the data sheet but I only wa…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Andrée Starå
  • Dashboard with Filters - Best Practice
    In Formulas and Functions
    Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this…
    Answered - Pending Review
    442 3
    Answered - Pending Review 442 views 3 comments Most recent by Genevieve P
  • 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
    29 10
    Accepted Answer 29 views 10 comments Most recent by Bianca Mitchell
  • Networkday counting excluding holidays
    In Formulas and Functions
    I am counting 2 dates in two separate columns and keep getting errors when I add the holiday syntax. What is the correct syntax.
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Mark Cronk
  • VLOOKUP + MATCH on column headers
    In Formulas and Functions
    Hi, I have a reference sheet set up with a list of milestone names/build versions/dates and am trying to use VLOOKUP + MATCH to auto-pull those in a 2nd sheet. For example - Sheet1 uses =VLOOKUP("ZBR", Milestones1:[2.0]7, MATCH(&…
    Answered - Pending Review
    17 4
    Answered - Pending Review 17 views 4 comments Most recent by Leslie Nivison
  • IF(AND) statement in Sheet Summary Field
    In Formulas and Functions
    Hello, I have searched and gotten close but no cigar yet! I'm trying to create and IF,AND statement in a Sheet Summary field, (defined as Data Type: Text/Number). I want one of two outputs in the Sheet Summary Field: "Active" wh…
    Accepted
    28 6
    Accepted Answer 28 views 6 comments Most recent by Chris Bader
  • Cross Sheet Formula for looking up a value when several columns meet a criteria. INDEX, MATCH, AND?
    In Formulas and Functions
    Help needed! 🙏 I have tried many variations of IF(AND...INDEX & MATCH Statements and I am so lost with what I should be using in this situation. 😓 I am working on a payroll calculator. I need to return a value for the Tentative Amount …
    Accepted
    27 5
    Accepted Answer 27 views 5 comments Most recent by KDM
  • Trying to count children (level 1) from a reference sheet
    In Formulas and Functions
    I hope some can help me. I need to count how many level 1 task I have on a reference sheet. I have no problem using the following formula in the sheet summary that the task are in and get the correct number of level 1children. =COUNT(CHIL…
    Accepted
    24 4
    Accepted Answer 24 views 4 comments Most recent by Sean Corcoran
  • Couple of Time Formula Questions
    In Formulas and Functions
    Background. I have 4 columns: Status, Status Date, IRB Submission Date, and IRB Elapsed Time. We want whenever the Status changes (In Preparation, Submitted, Approved, Complete, Cancelled) to record the date. I thought this formula would…
    Answered - Pending Review
    26 2
    Answered - Pending Review 26 views 2 comments Most recent by Mark Cronk
  • Return cells containing numbers as text string
    In Formulas and Functions
    how can I keep the number formatting of a cell in a formula? If I want to combine text and number, it reverts the number format to the blank number without decimals and thousands separator.
    Answered - Pending Review
    25 6
    Answered - Pending Review 25 views 6 comments Most recent by Andrée Starå