Formulas

Discussion List

  • RGB Formula for Multi-Dropdown
    In Formulas and Functions
    Hi - 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…
    Accepted
    19 3
    Answered ✓ 19 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Combining Form Submission Data with Already Existing Row Data
    In Using Smartsheet
    Hello 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…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Shimanta Roy Using Smartsheet
  • duplicates formula
    In Formulas and Functions
    Hi 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 …
    Accepted
    74 16
    Answered ✓ 74 views 16 comments Most recent by Ankie Formulas and Functions
  • Using sumifs to tally up certain date ranges
    In Formulas and Functions
    Hi 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 1
    Answered - Pending Review 15 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Smartsheet formula
    In Formulas and Functions
    Hi, 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 …
    Accepted
    15 1
    Answered ✓ 15 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Formula for Count with multi-select columns
    In Formulas and Functions
    I'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…
    Accepted
    17 2
    Answered ✓ 17 views 2 comments Most recent by Sam C Formulas and Functions
  • IF/OR Quarters Formula
    In Formulas and Functions
    Hello! 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…
    Accepted
    14 3
    Answered ✓ 14 views 3 comments Most recent by SofiRuiz Formulas and Functions
  • CountIF for whole column Not just a range of rows
    In Formulas and Functions
    I'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…
    Accepted
    15 1
    Answered ✓ 15 views 1 comment Most recent by Jeff Reisman Formulas and Functions
  • Looking for most recent date
    In Formulas and Functions
    I 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 …
    Accepted
    766 9
    Answered ✓ 766 views 9 comments Most recent by Genevieve P. Formulas and Functions
  • Vlookup issue : When column are added to
    In Using Smartsheet
    Hi, 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…
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå Using Smartsheet