Formulas

Discussion List

  • CountIf with Multiple Criteria + Mutli-Sheet Reference
    In Formulas and Functions
    Hello, I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet. Here's my cu…
    Accepted
    4 2
    Accepted Answer 4 views 2 comments Most recent by luke_morales Formulas and Functions
  • IF Statement
    In Formulas and Functions
    Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that h…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Devin Lee Formulas and Functions
  • Using AND with IF to check two text fields
    In Formulas and Functions
    Hi All, I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below; Range 1 is a single selec…
    Accepted
    13 3
    Accepted Answer 13 views 3 comments Most recent by James Raikes Formulas and Functions
  • Return Column Names AND values from row in a reference column
    In Using Smartsheet
    I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction i…
    Answered - Pending Review
    43 11
    Answered - Pending Review 43 views 11 comments Most recent by Genevieve P. Using Smartsheet
  • Formula Help, conditional formatting/If statement
    In Formulas and Functions
    I need a calculation to occur when criteria are met in another cell. For example, I want column D1 to reflect the following: if column A1 contains "Yes", I want the sheet to multiply column C1 by .10. If A1 contains, "N…
    Answered - Pending Review
    13 4
    Answered - Pending Review 13 views 4 comments Most recent by LMallery Formulas and Functions
  • Solution for spreadsheet VLookUp type function from another sheet to populate drop down?
    In Formulas and Functions
    I'm looking to populate a dropdown based on "VLookUp" values from another sheet. Is there a clever way to mimic a dynamic drop-down based on another sheet in Smartsheet?
    Accepted
    23 4
    Accepted Answer 23 views 4 comments Most recent by 404.IRL Formulas and Functions
  • CountIf Status Last 30 Days & Next 90 Days
    In Formulas and Functions
    Hello, I have a sheet that has a columns that include Status, Start Date & Finish Date. I need a countif formula that will pull back how many Completed (Status) have fallen within the last 30 days (Finish Date). I need a countif formul…
    Accepted
    24 5
    Accepted Answer 24 views 5 comments Most recent by Genevieve P. Formulas and Functions
  • How to include an if statement
    In Formulas and Functions
    I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x i…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Combining AND with HAS and WEEKNUMBER
    In Formulas and Functions
    Hello Again, My goal is to have a formula that will do the following: If the Lot [email protected] is found on the {Lot ID} column on an Archive sheet AND The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@r…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Very simple IF formula
    In Using Smartsheet
    Hi, I’m trying to create a very simple IF formula, but keep getting back the #Unparseable error. I know that error is for syntax, so since it’s such a simple formula, I copy/pasted the formula from the IF FUNCTION section from Help & …
    Accepted
    11 5
    Accepted Answer 11 views 5 comments Most recent by Paul Newcome Using Smartsheet