Formulas

 

Discussion List

  • Calculating SLA based on time/hour formula
    In Formulas and Functions
    Hi @Paul Newcome I thought I would write a new thread and @ your name on this post. Hope thats ok. Taking this from Formulas for Calculating Time thread. ------------------------------------------------------------------------------------…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Syed Muhafzal Formulas and Functions
  • Math formulas across multiple cells
    In Formulas and Functions
    Hello all, Any help on the following issue would be very much appreciated. I have a scoring matrix built in to Smartsheet (See below). I would like to multiply the score of each cell for each criteria (Strategic Init Impact Score, Busines…
    Accepted
    17 14
    Accepted Answer 17 views 14 comments Most recent by Bassam Khalil Formulas and Functions
  • Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
    In Formulas and Functions
    I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don'…
    Unresolved
    15 3
    Question 15 views 3 comments Most recent by CAI-RAS Formulas and Functions
  • Dashboard with Filters - Best Practice
    In Formulas and Functions
    Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this…
    Answered - Pending Review
    1352 5
    Answered - Pending Review 1.4K views 5 comments Most recent by Genevieve P. Formulas and Functions
  • Finding Distinct Values in Two Columns
    In Formulas and Functions
    Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am g…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Brett Wyrick Formulas and Functions
  • Return Value if Between Dates
    In Formulas and Functions
    Hello! I have a [DATE SUBMITTED] column and need to create a reference column that returns the fiscal year that date falls in. Something like this -  =IF [DATE SUBMITTED] > 10/01/17 AND [DATE SUBMITTED] < 09/30/18 RETURN "FY18…
    sjy Profile Photo sjy
    2261 4
    2.3K views 4 comments Most recent by Jasmine Formulas and Functions
  • Formula need to separate mixed text from a single column into separate columns
    In Formulas and Functions
    Using the LEFT or RIGHT formula currently as a means to separate the [Sales Rep Info] column. Problem is I can only figure out how to do it by number of characters. I need the formula to separate first and last name into a new column an…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Sarah Keortge Formulas and Functions
  • Check for Duplicates and Blanks
    In Formulas and Functions
    I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple b…
    Accepted
    6 2
    Accepted Answer 6 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Sumifs Formula with a Contain
    In Formulas and Functions
    I am trying to get the sum of hours worked IF the "Office" Column = Administrative Solutions. The Office column is a multi-select dropdown. =SUMIFS({Project Intake with Form Range 1}, {Project Management Tracker- Discovery to C…
    Accepted
    11 4
    Accepted Answer 11 views 4 comments Most recent by Maria Watters Formulas and Functions