Formulas

Discussion List

  • COUNTIFS counting mismatch
    In Formulas and Functions
    Hi folks, Any help appreciated with this...I have some miscounting and can't seem to work it out...arrrgh! If I filter my main sheet as follows: The result is a count of 16, which is correct. However, my formula to achieve the same on a su…
    Accepted
    25 4
    Accepted Answer 25 views 4 comments Most recent by Del Horne Formulas and Functions
  • Using Index with Collect to Copy information from one sheet to another sheet for an entire column
    In Formulas and Functions
    Hello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula u…
    Answered - Pending Review
    29 1
    Answered - Pending Review 29 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Unparseable error with "IF"
    In Formulas and Functions
    Good day everyone, I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here. Here's the formula that I'm using: The thing what I want to do is if the Grow…
    Accepted
    15 2
    Accepted Answer 15 views 2 comments Most recent by Yahaira Paredes Formulas and Functions
  • Create a list from check marks in a grid
    In Formulas and Functions
    I need to pull data from a grid organized like this (with yellow items being being column headings): into a list that is structured like: I am stumped on how to do it. I do not own the original data so I cannot restructure it into a diffe…
    Answered - Pending Review
    26 4
    Answered - Pending Review 26 views 4 comments Most recent by Matthew Barrett Formulas and Functions
  • SUMIFS with Multiple Conditions and Two Children Rows
    In Formulas and Functions
    Hi! I'm trying to work out the SUMIFS formula for a summary sheet based on multiple criteria that will SUM from two different children sum rows. Row 3 and Row 42 have the SUM(CHILDREN()) formula in those columns. I can do it for one chil…
    Answered - Pending Review
    3 1
    Answered - Pending Review 3 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Error in WEEKDAY formula
    In Formulas and Functions
    I'm struggling with a formula that seems to be broken. I created a timesheet that has a cell that looks at the Auto Date/Time stamp and calls up the weekday. The formula is as follows: =WEEKDAY([Date/Time]129) It works great...unless th…
    23 2
    23 views 2 comments Most recent by itsnotbroken Formulas and Functions
  • SUMIFS I think?
    In Formulas and Functions
    I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is:…
    Accepted
    15 5
    Accepted Answer 15 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Formula to return different values
    In Formulas and Functions
    Hello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF([email protected] <…
    Accepted
    15 3
    Accepted Answer 15 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
    In Formulas and Functions
    Hello, I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formul…
    Accepted
    14 3
    Accepted Answer 14 views 3 comments Most recent by Paul H Formulas and Functions
  • Sheet Name within a Cell
    In Formulas and Functions
    Hello,   I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i n…
    531 2
    531 views 2 comments Most recent by MelodyD Formulas and Functions