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

  • VLOOKUP matching text, referencing another sheet
    In Formulas and Functions
    I am trying to match a vendor name between two sheets and if it is found to display a risk rating from the other sheet. I am getting the error message #UNPARSEABLE with the formula below. What am I doing wrong? =VLOOKUP("[Vendor Nam…
    Accepted
    7 2
    Accepted Answer 7 views 2 comments Most recent by Genevieve P
  • formulas in a form
    In Formulas and Functions
    Hello, I've created a form with an email and a user name field. I would like the user name to default to the value entered in the email address field. Is there a way to use logic or formulas in the construction of the form to accomplish th…
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Khari Shiver
  • IF AND formulas
    In Formulas and Functions
    I can't get the following formula to work, getting the #UNPARSEABLE error: =IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moder…
    Accepted
    20 5
    Accepted Answer 20 views 5 comments Most recent by Mark Cronk
  • Countif w/ multi drop down
    In Formulas and Functions
    Hi, I have a list of drop down items: I am trying to total the amount of those selected on another sheet. (How many rows contain those three items bundled together). I am getting an error message when I try: =COUNTIFS({LOA Tracker Range …
    Accepted
    14 5
    Accepted Answer 14 views 5 comments Most recent by Mark Cronk
  • Vlookup or IF statement
    In Formulas and Functions
    Hi, I have one sheet where I have an attendance list. I have another sheet where I have opportunity logging. From my opportunity logging sheet, I want to do a vlookup (I think ) of the email address to my attendance sheet email address.…
    Accepted
    17 5
    Accepted Answer 17 views 5 comments Most recent by Mark Cronk
  • Lock Filter option in Collaboration mode
    In Formulas and Functions
    How do I lock the filter option when there are other collaborators to prevent changing the order of the sheet but still allowing cell comments?
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Bassam Khalil
  • Setting up a Workflow
    In Formulas and Functions
    I have a column in my Smartsheet for responsible person. I would like to set up a workflow that will send out an email to the person that is placed into the responsible person column, but would like to set it up where only one email is sen…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Bassam Khalil
  • How to make a COUNTIFS Formula work
    In Formulas and Functions
    Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff …
    Accepted
    39 10
    Accepted Answer 39 views 10 comments Most recent by Heather D
  • Adding 1 day to date in an If formula
    In Formulas and Functions
    Hello. I am trying to add one day to a date if the row meets a certain condition. Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the for…
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Leibel S
  • Sheet Summary COUNTIFS using netdays
    In Formulas and Functions
    I am trying to count how many requests are open for more then 2 days in sheet summary. The above formula results in #UNPARSEABLE
    Answered - Pending Review
    8 4
    Answered - Pending Review 8 views 4 comments Most recent by Jenifer Salvetti