Formulas and Functions
Archives for February 2019
Discussion List
-
First post 02/28/19,Last post 03/01/19I 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…Formulas and Functions38Nicole Paulsen -
First post 02/28/19,Last post 03/01/19I 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…Formulas and Functions24Heather K
-
First post 02/28/19,Last post 03/05/19Good 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? ThanksFormulas and Functions24879BESP10 -
First post 02/28/19,Last post 02/28/19I 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…Formulas and Functions42johnvilsack
-
First post 02/27/19,Last post 06/25/20Hello 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…Formulas and Functions7253SeanR
-
Create column with unique values from another columnAccepted AnswerAccepted Answer Heather K 417 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/19,Last post 01/06/20I 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…Formulas and Functions4175Heather K
-
First post 02/27/19,Last post 02/28/19Greetings, 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…Formulas and Functions22910jcarter67946 -
First post 02/27/19,Last post 02/27/19Hello, 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 …Formulas and Functions437Randy Van Winkle
-
First post 02/27/19,Last post 02/27/19Within 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…Formulas and Functions115ed.jaro -
First post 02/27/19,Last post 02/27/19I 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…Formulas and Functions161Karina.Perez
-
First post 02/27/19,Last post 03/04/19Hello, My formula below keeps coming back unparsable and I can't figure out why...The column I need to be summed is referenced first in Range 2. I am also referencing the same date column for that Month and Year criterion. It's on the ti…Formulas and Functions834daniel68616
-
First post 02/27/19,Last post 02/27/19Hi all, 2 in May and 2 in June right? 4 total Why does the 2nd row show 3? Darrell (Image)Formulas and Functions21djpreece
-
First post 02/26/19,Last post 02/27/19This is the formula I am trying to activate to pull some sales data from a master sheet to a monthly summary by sales person. =SUMIFS({Current Lead Opportunity Tracker 2019 Range 3}, {Current Lead Opportunity Tracker 2019 Range 1}, "…Formulas and Functions871Pepenav
-
First post 02/26/19,Last post 03/04/19Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you ! (Image)Formulas and Functions1335BESP10
-
First post 02/26/19,Last post 02/26/19Hello! 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…Formulas and Functions7692sjy
-
First post 02/26/19,Last post 02/26/19I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be &…Formulas and Functions4693Mary Ayers -
First post 02/26/19,Last post 04/02/19I am adding new entries to a sheet daily. I need to know on a given date how many entries were added to the sheet. I need to be able to adjust this daily. I have created something on a google doc that works very well but I can't seem to du…Formulas and Functions1326jnevills66866 -
First post 02/26/19,Last post 02/26/19I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes How can I do a count by Manager of Product? Example: Joe Smith * Product1 - 3 * Product2 - 10 Jenni…Formulas and Functions114Amanda Chu
-
First post 02/26/19,Last post 02/27/19There is a column called "Terminated" and it is a checkbox and 5 other columns with Product1, Product2, Product3, Product4, and Product5 which are also checkboxes. I need a formula to COUNTIF "Terminated" is Checked, …Formulas and Functions503Amanda Chu
-
First post 02/26/19,Last post 02/26/19I have a column called "State". How can I do a count by all "State" and produce a chart? I want to avoid doing a formula for each State. Suggestion?Formulas and Functions389Amanda Chu
-
First post 02/26/19,Last post 03/16/20I created a form. new entries are entered at the bottom of the form. I copied all of my formulas to the bottom of the form. When new entries come in from the form, they come in below the last row where formulas are copied. Result...formula…Formulas and Functions3110steve50951
-
First post 02/26/19,Last post 04/02/19Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I d…Formulas and Functions403cjleon
-
First post 02/26/19,Last post 02/27/19Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overd…Formulas and Functions176David Muskett
-
First post 02/25/19,Last post 02/26/19I have been using the month formula to create a month number from an 'Actual close date' column. however i get error when the source column 'Actual close date' is blank I can get the month number to work when dates are included with =MON…Formulas and Functions713Pepenav
-
First post 02/25/19,Last post 03/01/19Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts. I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell …Formulas and Functions983kapears76161 -
First post 02/25/19,Last post 03/12/19Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was chec…Formulas and Functions964bhope51
-
First post 02/25/19,Last post 02/25/19I'm looking to take a Smartsheet I created for my department and to share it with other teams. It's fairly simple, but I have a few formulas doing some stuff: * A Status Ball that syncs with the status text. * A formula in a PARENT_PROJE…Formulas and Functions381johnvilsack
-
First post 02/25/19,Last post 02/26/19Hi Everyone, New smartsheet user here, I am trying to get a total cost between dates on a running construction schedule. I have different row-categories (Land acquisition, permitting, site work, construction, & selling) with columns s…Formulas and Functions127aartiano
-
First post 02/25/19,Last post 02/26/19I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it! (Image) (Image)Formulas and Functions604steve50951
-
First post 02/25/19,Last post 02/26/19Hi there, I am looking to include a metrics widget on my portfolio dashboard for all completed projects in FY20. Our fiscal year runs 2/1/19 through 1/31/20 (or alternately, this could just be completed projects in Feb 2019 and after, the…Formulas and Functions282Lchicklis
