Formulas

Discussion List

  • Formulas and functions in forms
    In Formulas and Functions
    Hi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Formula Woes
    In Formulas and Functions
    My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
    66 11
    66 views 11 comments Most recent by Cat Werbeck Formulas and Functions
  • Checkbox formula with percentage
    In Formulas and Functions
    Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
    Accepted
    15 10
    Accepted Answer 15 views 10 comments Most recent by David Tutwiler Formulas and Functions
  • how to make decimals work?
    In Using Smartsheet
    Hi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example: =IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01) how can i multply with decimals? Thanks
    Answered - Pending Review
    3 3
    Answered - Pending Review 3 views 3 comments Most recent by John Jonassen Using Smartsheet
  • Imported Formulas from Excel
    In Formulas and Functions
    Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it…
    Answered - Pending Review
    12 5
    Answered - Pending Review 12 views 5 comments Most recent by Cat Werbeck Formulas and Functions
  • Pulling data from a sheet
    In Formulas and Functions
    Good Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that rec…
    Accepted
    12 4
    Accepted Answer 12 views 4 comments Most recent by David Tutwiler Formulas and Functions
  • Gathering data from 1000 sheets
    In Using Smartsheet
    Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Daniel Dragoun Using Smartsheet
  • URL Query string did not move with "Save as New" How to remedy?
    In Formulas and Functions
    I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query stri…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Ben G Formulas and Functions
  • Formula to count total number of items selected in a column of multi-select fields
    In Formulas and Functions
    Hi, I have a column called Type, which I've set up as a multi-select drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created…
    Answered - Pending Review
    1 1
    Answered - Pending Review 1 view 1 comment Most recent by David Tutwiler Formulas and Functions
  • Using If Formula to Populate Status of Parent Row
    In Formulas and Functions
    I am looking for help writing a formula to populate a parent row of a Single Select Dropdown column. The Parent row should reflect the Status of the Child rows - for instance, if any of the Child row statuses are set to Not Started, In Pro…
    Answered - Pending Review
    18 3
    Answered - Pending Review 18 views 3 comments Most recent by Bridgett Alonso Formulas and Functions