Formulas and Functions

Discussion List

• Formula Sumif Range w. Web Form

  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, T…

  Construction

  Formulas

  Support

  Formulas and Functions

  131

  Mar 1, 2019

  8

• Issue with Nested IF Formula

  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(…

  Formulas

  Formulas and Functions

  131

  Mar 1, 2019

  4

• CountIf for check boxes

  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

  Answered ✓

  Formulas

  Conditional Formatting

  Formulas and Functions

  37680

  Mar 23, 2022

  29

• Calculate Points of Symbols?

  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 …

  Formulas

  Formulas and Functions

  181

  Feb 28, 2019

  2

• Relational Database?

  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.…

  Sales

  Formulas

  Cell linking

  Formulas and Functions

  7252

  Oct 4, 2022

  5

• Create column with unique values from another column

  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…

  Answered ✓

  Formulas

  Formulas and Functions

  1723

  Nov 25, 2022

  8

• Percentage Complete Column (Breaks)

  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 so…

  Sheets

  Formulas

  Project Management

  Formulas and Functions

  1344

  Feb 28, 2019

  10

• Date Formlulas for Dashboard Counter

  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: …

  Formulas

  Formulas and Functions

  261

  Feb 27, 2019

  7

• Posting/Including data from another cell.

  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…

  Sheets

  API and Developers

  Formulas

  Formulas and Functions

  141

  Feb 27, 2019

  5

• Countifs Formula using a date range given

  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 on…

  Formulas

  Cell linking

  Formulas and Functions

  141

  Feb 27, 2019

  1