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

  • Formula INDEX/COLLECT CLIENT VALUE by MONTH
    In Formulas and Functions
    =INDEX(COLLECT({Sales Pipeline Range 1}, {Sales Pipeline Range 3}, @cell = [Account Name]@row, (SUMF{Sales Pipeline Range 6}, MONTH(@cell) = 1)) I want a formula that recognises on a referenced sheet a client name, and totals the value by …
    Unanswered
    4 0
    Question 4 views 0 comments Started by Michelle Maas
  • Dates in IFS Statement
    In Formulas and Functions
    I am trying to use dates (formatted in dates columns) in an IFS statement to compare dates in multiple columns and provide calculations based upon whether a date is before or after (<>) a certain date. I am getting an #UNPARSEABLE er…
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by Andrée Starå
  • Can i populate data referring to multi select drop down(as a primary key)?
    In Formulas and Functions
    i have a column with multi select drop down option, i need to populate the data from another sheet referring to the drop downs select. How can i refer the first column as primary key to populate the rest of the data. My primary key would b…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Umme Salma
  • Find first non-empty cell
    In Formulas and Functions
    Hi, What formula can I use in the Current Email Helper column to accomplish the below Desired Outcome. I'm not using a hierarchy so I cant use CHILDREN()/PARENT() functions. Here's the kind of logic I'm trying to follow: IF [Email]@row is…
    Answered - Pending Review
    35 5
    Answered - Pending Review 35 views 5 comments Most recent by Andrée Starå
  • Dashboard question- Can I add a list of locations to click on and all of the widgets update?
    In Formulas and Functions
    Like in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå
  • COUNTIF of CHILDREN with HAS
    In Formulas and Functions
    I'm running into an issue with a formula that I'm trying to write that counts the results of a multi-dropdown column using the CHILDREN hierarchy. =COUNTIF(CHILDREN([Event Tier]165), HAS(@cell, "Tier 1: Off-Site Event")) I'm lo…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå
  • Nested MAX formula
    In Formulas and Functions
    Is there a way to use the MAX formula to look at a created column and check a box for the last entry of each day? I'm having no trouble getting the MAX to work for the full sheet, but it's not working for each day. I'm looking at the cre…
    Unanswered
    7 0
    Question 7 views 0 comments Started by Leslie Merlino
  • Column formula from a template not allowing me to edit
    In Formulas and Functions
    I downloaded a Smartsheet template and am now listed as the owner, however it is not allowing me to edit a column formula. The column isn't locked, but the formula is somehow.
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Shannon23
  • SalesForce Connector
    In Formulas and Functions
    I need to filter on multiple account id's in the connector. There is not an option to do this. Is there a work around?
    Unanswered
    5 0
    Question 5 views 0 comments Started by Pam Parrish
  • (Count if) And & Or
    In Formulas and Functions
    I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by JKremer