Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • Batch rename hyperlinks
    In Formulas and Functions
    Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do this one by one. (multiple sheets wi…
    499 2
    499 views 2 comments Most recent by Brad Jones
  • If then statement for a list of individuals
    In Formulas and Functions
    Good day! I am trying to reference one cell in my spreadsheet that has a drop down list of 30+ people in the list.  I want to create another cell using the if then formula to say if person a, person, c, and person h are in the first cell,…
    111 1
    111 views 1 comment Most recent by Mike Wilday
  • Uncheck the previous checkbox when a new box is checked
    In Formulas and Functions
    Hello How do I get rid of a previous check when a new checkbox is selected?   This is what really need to happen: (Task Name 6 needs to transition from one to another (Idea, Concept, Design, Validation, Lanuch) as the approvals are sent…
    301 2
    301 views 2 comments Most recent by Chris McKay
  • How to add few texts/words on countif(s) formula
    In Formulas and Functions
    Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smarsheet but works in Excel. Below is the …
    141 3
    141 views 3 comments Most recent by Chris McKay
  • Vlookup
    In Formulas and Functions
    I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another sheet that I am using to track open i…
    11 2
    11 views 2 comments Most recent by Debbie J
  • RYG formula in response to a numbered cell
    In Formulas and Functions
    I am having a bit of trouble figuring out how to write a formula to automate RYG symbols. Basically I want the rules to be as follows: 1. If value is less than 4, RED 2. If value is greater than 4 but less than 6, YELLOW 3. If value is …
    1 3
    1 view 3 comments Most recent by rnye
  • Moving Rows with a Formula
    In Formulas and Functions
    Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list.    Thank you for your help, Sohlbe
    21 1
    21 views 1 comment Most recent by Chris McKay
  • Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.
    In Formulas and Functions
    I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my tot…
    102 1
    102 views 1 comment Most recent by Taylor F
  • Issues with the new cross sheet formulas?
    In Formulas and Functions
    My totals were working finally on a summary sheet but then all the columns started changing to the same formula.  I tried twice to go in and reset the reference sheet range but then it would just everything on the sheet.  Anyone else have …
    1 1
    1 view 1 comment Most recent by Taylor F
  • UPPER formulas
    In Formulas and Functions
    Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
    151 1
    151 views 1 comment Most recent by Taylor F