Formulas
Discussion List
-
Calculating SLA based on time/hour formulaIn Formulas and FunctionsHi @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. ------------------------------------------------------------------------------------…
-
Math formulas across multiple cellsIn Formulas and FunctionsHello 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…
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheetIn Formulas and FunctionsI'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'…
-
Dashboard with Filters - Best PracticeIn Formulas and FunctionsHi 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 1.4K views 5 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Finding Distinct Values in Two ColumnsIn Formulas and FunctionsHi, 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 views 1 comment 0 points Most recent by Brett Wyrick Formulas and Functions
-
Return Value if Between DatesIn Formulas and FunctionsHello! 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…
-
Formula need to separate mixed text from a single column into separate columnsIn Formulas and FunctionsUsing 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 views 1 comment 0 points Most recent by Sarah Keortge Formulas and Functions
-
Check for Duplicates and BlanksIn Formulas and FunctionsI 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…
-
Sumifs Formula with a ContainIn Formulas and FunctionsI 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…
