Formulas and Functions

Archives for February 2019

Discussion List

  • Formula Sumif Range w. Web Form
    In Formulas and Functions
    I have a sheet where I am using a Webform to gather data.  Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform ent…
    1 view 8 comments Most recent by Mike Wilday Formulas and Functions
  • Issue with Nested IF Formula
    In Formulas and Functions
    I am having trouble getting my nested if formula to work. I have the following formula: =IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([D…
    2 4
    2 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • CountIf for check boxes
    In Formulas and Functions
    Good afternoon,    Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box?   Thanks    
    3727 9
    3.7K views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Calculate Points of Symbols?
    In Formulas and Functions
    I have three symbol fields Priority (uses Priority High, Low), Impact (uses Measure One, Two, Three, Four, Five), and Size (uses Measure One, Two, Three, Four, Five) I would like to roll up points in a column for this.  Impact and Size wo…
    1 view 2 comments Most recent by johnvilsack Formulas and Functions
  • Relational Database?
    In Formulas and Functions
    Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
    965 4
    965 views 4 comments Most recent by netizenden Formulas and Functions
  • Create column with unique values from another column
    In Formulas and Functions
    I am working on creating a sheet to be used for reporting. I have pulled in the contact list of names using the cell linking feature however, there are multiple rows with the same person. I would like to create a column listing just unique…
    Accepted
    495 5
    Accepted Answer 495 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Percentage Complete Column (Breaks)
    In Formulas and Functions
    Greetings, I've discovered that the % Complete Column in a few of my sheets has broken, is incomplete at calculating the true completion percentage for a project. I suspect this might have happened somewhere along the line of adding/remo…
    259 10
    259 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Date Formlulas for Dashboard Counter
    In Formulas and Functions
    Hello, Trying to set up formulas from a sheet to post to a dashboard, somehow came up short.  I have a number of projects listed in my sheet with a [Go Live] date. I would like to count the following: * Number of projects that are within …
    42 views 7 comments Most recent by Mike Wilday Formulas and Functions
  • Posting/Including data from another cell.
    In Formulas and Functions
    Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement i…
    11 5
    11 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Countifs Formula using a date range given
    In Formulas and Functions
    I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to only count if is it in between (and incl…
    12 views 1 comment Most recent by Paul Newcome Formulas and Functions