Formulas and Functions

Archives for August 2019

Discussion List

  • Server/Local sheets get out of sync, some permanently
    In Formulas and Functions
    Hi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server…
    102 2
    102 views 2 comments Most recent by djpreece Formulas and Functions
  • Formula is not copying
    In Formulas and Functions
    Hi, I am having a problem with one formula that is not automatically copying to a new row (there are others that are being copied). The formula is: =JOIN(CHILDREN([Column Name]1, ", ") Why every other formula is being copied bu…
    86 9
    86 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • Master Sheet - Exceeds Row Limit
    In Formulas and Functions
    I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master custome…
    211 7
    211 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • Locking Cell - with Conditions
    In Formulas and Functions
    Is there any way to lock/restrict a cell that asks users to choose a date?  For example, I want users to be able to choose a date earlier than what is "listed" in the cell but be unable to choose a date after the date that is lis…
    275 4
    275 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Index, Match with Find and Left function
    In Formulas and Functions
    I am trying to get a formula to look up a value with the INDEX / MATCH function and the Search_Value being the numbers up to a "-" dash from the "Type For List" column. The index/match does not seem to like the LEFT or…
    390 10
    390 views 10 comments Most recent by L_123 Formulas and Functions
  • Formula to change text
    In Formulas and Functions
    Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is withi…
    63 1
    63 views 1 comment Most recent by L_123 Formulas and Functions
  • =ROUND(SUMIF
    In Formulas and Functions
    Hi  =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in th…
    269 2
    269 views 2 comments Most recent by Amy Scherer Formulas and Functions
  • Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being delete
    In Formulas and Functions
    Hello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links&qu…
    182 7
    182 views 7 comments Most recent by Jaye Casciano Formulas and Functions
  • Formula that averages a column
    In Formulas and Functions
    HI Smartsheet community, I need a formula that averages one column (# of jobs) if a checkbox is checked.  I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right.  Help! -Bridget Sloane
    11 3
    11 views 3 comments Most recent by L_123 Formulas and Functions
  • Mandatory Fields on Smartsheets
    In Formulas and Functions
    Hi, Is there any way to make the category field and the risk level field mandatory for users to complete before they can change the status from open to closed in my Smartsheet? Currently we have users who are just closing the status witho…
    1957 14
    2K views 14 comments Most recent by Sandra Fernandez Formulas and Functions