Formulas
Discussion List
-
RGB Formula for Multi-DropdownIn Formulas and FunctionsHi - I'm looking for some help with a formula. I am using multiple RGB fields and would like the RGB to appear as Green unless its Area is selected from the multi-dropdown field where it would then be red. RGB Area 1 - Green (or Red if sel…
-
Combining Form Submission Data with Already Existing Row DataIn Using SmartsheetHello All, I'm looking for a way to combine form submission data with data that already exists in a row. For example my row has the item information for something we're trying to resell. The form goes out to the resell companies for them…
-
duplicates formulaIn Formulas and FunctionsHi Experts: I would like to identify the duplicated in column Model# and than mark the once which have the lowest article#. The one marked in red are the once which should be marked in column model count. It's getting complicate as the …
-
Using sumifs to tally up certain date rangesIn Formulas and FunctionsHi All. I'm working to understand the more complex formulas of smartsheet but have been stumped. I'm looking to sum the work area total amount of a task based on the start and finish dates on the Gantt chart. I want to see what we will bil…Answered - Pending Review 15 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Smartsheet formulaIn Formulas and FunctionsHi, Some help would be great if possible, I need to get this working on an if statement if possible. I need it to look for a [Range_Complexity]@row called "Complex" and if so change the formula to this =WORKDAY([Lock Off (Online …
-
Formula for Count with multi-select columnsIn Formulas and FunctionsI've been trying to figure out how to write the formula to determine how often a specific multi-select option has been selected in a single column and I keep hitting a wall. This is what I have, but I think it needs to be a "COUNTIF&q…
-
IF/OR Quarters FormulaIn Formulas and FunctionsHello! I am trying to come up with a formula to assign Quarters to a sheet, based on if the month is 1, 2, 3, etc. (Jan, Feb, Mar, etc.) I am trying to use IF(OR and I get it to work until Q2, but for some reason when I add Q3 section (hi…
-
CountIF for whole column Not just a range of rowsIn Formulas and FunctionsI'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World C…
-
Looking for most recent dateIn Formulas and FunctionsI have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
-
Vlookup issue : When column are added toIn Using SmartsheetHi, I have successfully applied a Vlookup from reference sheet to my parent sheet. However, when a new column is added within that range in reference sheet then input value also changes and it doesn't remain static. Is there a way to apply…