Formulas and Functions
Archives for December 2019
Discussion List
-
SUMIF Halp!Accepted AnswerAccepted Answer ryan.diamond55371 31 views 9 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/31/19,Last post 12/31/19So I have this issue I would love to solve. I have a Contract Database (Sheet #1) that holds a current contract value for that contract number (216116). My issue is pulling the child row value (Total Contract Value) to another sheet (Sheet…Formulas and Functions319ryan.diamond55371
-
Answered - Pending Review Christopher Pretty 33 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/31/19,Last post 12/31/19Hi Smartsheet hive mind. Hopefully someone may be able to answer this question. I have a sheet (Sheet A) that will be tracking tickets and will have the dates the ticket was created on it. I have another sheet (Sheet B) that has every date…Formulas and Functions335Christopher Pretty -
Help with formula for multiple criteriaAccepted AnswerAccepted Answer dakissee108951 12 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/31/19,Last post 12/31/19=COUNTIF([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")Formulas and Functions123dakissee108951
-
First post 12/31/19,Last post 01/15/20In the created project management fields, there is a start and end dates for the task assigned to the person I would like to inquire about the following cases: When I delay the task completion date, for example 3 days, how can I later revi…Formulas and Functions566wabel adnan alzaeem
-
Report Based on Multi Select Dropdown ColumnAccepted AnswerFirst post 12/30/19,Last post 01/02/20I have a master schedule that includes a multi select dropdown column for disciplines associated with each individual project. I need to create a report that shows all projects with multiple disciples selected. It needs to allow any combin…Formulas and Functions1715coryg
-
How do I sum up the last two characters of a cell?Accepted AnswerAccepted Answer SuzanneH 11 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/19,Last post 12/31/19I have a column where the last two characters are a number. If I do Value(right(cell,2) I get the correct number. I can also add Value(right(cell1,2) +Value(right(cell2,2) But I would like to calculate a cell to be the sum of the right…Formulas and Functions113SuzanneH
-
Summing a columnQuestionAnswered - Pending Review SuzanneH 46 views 3 comments 0 points Most recent by SuzanneH Formulas and FunctionsFirst post 12/30/19,Last post 01/02/20Hi, I would like to count all the rows in a column where the value matches a specific cell. I can get this to work using countif however I can't get it to work when the column is variable. For example Cell A1 = "Yellow", Cell D…Formulas and Functions463SuzanneH
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow StaQuestionAnswered - Pending Review Molly Morton 21 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/19,Last post 12/30/19Looking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date…Formulas and Functions212Molly Morton
-
Accepted Answer SuzanneH 125 views 10 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/19,Last post 03/25/20I have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the gr…Formulas and Functions12510SuzanneH
-
Answered - Pending Review Janie Heuck 25 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/19,Last post 12/30/19I literally just started on this yesterday. we have 7 or so departments and projects within each. Our business is a winery--so departments are Production, Hospitality, Wine Club, PR, Marketing etc. Some assignees cross over to projects i…Formulas and Functions251Janie Heuck -
Want to count number of instances in a columnAccepted AnswerAccepted Answer Rene Montijn 206 views 13 comments 0 points Most recent by Ezra Formulas and FunctionsFirst post 12/30/19,Last post 01/07/20HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/port…Formulas and Functions20613Rene Montijn -
Answered - Pending Review jlheaney 41 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/27/19,Last post 01/16/20Hi All! I am wondering if this functionality is possible. I have created a sheet and once a row is populated is it copied to a new sheet for my employees. There is a 'Completion Date" field, I would like for them to complete when that…Formulas and Functions414jlheaney
-
SUMIFs not working in Smartsheet VS ExcelAccepted AnswerAccepted Answer Jia Lee 38 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 12/26/19I have the following table (Image) in excel if i use the function =SUMIFS($C$2:$C$5,$A$2:$A$5,101,$B$2:$B$5,"Approval") it will return the value of the approval date - 1/1/2020 however when i do this in smartsheet, the formula …Formulas and Functions385Jia Lee
-
I need help bucketing some dataAccepted AnswerAccepted Answer Brian Erdelyi 33 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 01/06/20I need help combining some data I have the following columns in sheet-1 · Year-1 Deliverable Date-1 (this is a date column) · Year-1 Deliverable-1 Amount (this is a currency column) · Year-1 Deliverable-1 Billing Quarter (t…Formulas and Functions333Brian Erdelyi -
Auto Date CalculationAccepted AnswerAccepted Answer Paul Raphael 47 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 02/06/20Hi, I have 3 column's - Days, Start Date, Completion Date. I would like to enter days and start date, and let Completion date auto calculate. So for example if I enter 30 in days and 6/14 in Start Date, I would like Completion Date auto …Formulas and Functions477Paul Raphael
-
Answered - Pending Review JennS_ 34 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 12/26/19I am trying to count the quantities of a specific "TYPE" , for a specific "OUTPOST", that are less than or equal to today's date. For example, I want to know how many "2P" for outpost NYC-2 are check-in live a…Formulas and Functions341JennS_
-
First post 12/26/19,Last post 12/26/19I need to select the string associated with each of the Tag names START: END: SCOPE: Are there command/s in Smartsheet to select the data and copy to a column on the same row as the string? Below is the example of data in a single Cell. …Formulas and Functions541Michael Tuccillo
-
Countifs and OR statementAccepted AnswerAccepted Answer Daryl Lee 45 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 12/26/19I'm trying to have a formula that will work if one column matches specific criteria and then if another column matches one of two criteria. I have been able to get it to work for one of the criteria from the second column by writing =(COU…Formulas and Functions455Daryl Lee
-
Calculate the total rows but exclude the same nameAccepted AnswerAccepted Answer Bengs 32 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/26/19,Last post 12/26/19What kind of function combination that i can use to calculate the total row but excluded the same name, as follows (green highlight). (Image)Formulas and Functions323Bengs
-
Accepted Answer FusiaSuede 46 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/25/19,Last post 01/06/20Good morning, After a long search I am finally reaching out. In my % Complete column I am using an IF(ISBLANK w/ Networkdays formula to get my percent complete number; Pulling dates from 'Proj. Task Launch' & 'Proj. Task Comp.' I can't…Formulas and Functions463FusiaSuede
-
Multiple IF function pull from multiple cellsAccepted AnswerAccepted Answer Jasmine Brown 68 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/24/19,Last post 01/14/20I am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row. I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected. cu…Formulas and Functions686Jasmine Brown
-
Apostrophe Added to FormulaAccepted AnswerAccepted Answer Sue Crawford (admin) 51 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/23/19,Last post 12/24/19I am trying to take a number from one column and have it automate into another column within a calculation. I am creating a new row through Zapier, which works perfectly...except for the apostrophe. This is the calculation I am wanting: =(…Formulas and Functions514Sue Crawford (admin)
-
Accepted Answer Chris White 78 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/23/19,Last post 12/26/19Hi, I am having issues getting a formula to work to show the value from a parent row in a child row when the parent row value is from a different column. For the example below I would want a formula for the Associated Project column to alw…Formulas and Functions784Chris White
-
Answered - Pending Review Rebekah Pound 64 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/23/19,Last post 12/27/19Hi there Community! #INVALID OPERATION has me beat today. I believe the issue is somewhere in the bold area bc when I pull that section out I don't get the "#INVALID OPERATION" error message. The error is only displays when the r…Formulas and Functions644Rebekah Pound
-
Answered - Pending Review Mariniel Bautista 53 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/23/19,Last post 12/23/19Hi. I am thinking of automating our Supplies Request using Smartsheet. Inside a Supplies Request Form, you can request more than 1 materials/supplies. What should I do inside a form to make requestor request more than 1 materials/suppli…Formulas and Functions532Mariniel Bautista -
Automated Printing of a Dashboard - or workaround to take a snapshot before month carries overQuestionAnswered - Pending Review SammyMorey 106 views 5 comments 0 points Most recent by SammyMorey Formulas and FunctionsFirst post 12/23/19,Last post 07/02/20Hey all, Hoping someone may be able to assist... We have dashboards that show the current live data and that automatically tick over as the months do and all the data changes. It is working fabulously, except we want to be able to take…Formulas and Functions1065SammyMorey
-
Parent Child NumberingAccepted AnswerAccepted Answer Stavros_McGillicuddy 155 views 11 comments 0 points Most recent by Stavros_McGillicuddy Formulas and FunctionsFirst post 12/21/19,Last post 03/23/20With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Gen…Formulas and Functions15511Stavros_McGillicuddy
-
Adding to a Complex FormulaAccepted AnswerAccepted Answer Ray B 43 views 13 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/21/19,Last post 01/02/20Good morning All: I am trying to add RYG to my Formula. Here are my conditions: If 15+ Days Behind Schedule = Red If Between 5-15 Days Behind Schedule = Yellow If 0 or Ahead of Schedule = Green Current Formula without RYG: =IF(ISBLANK([A…Formulas and Functions4313Ray B
-
Answered - Pending Review Terri Pavlovic 107 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/20/19,Last post 12/20/19I want another sheet to reference a sheet summary field, but I can't figure out how to do the cross sheet reference. Can you access sheet summary fields from another sheet?Formulas and Functions1071Terri Pavlovic
-
Answered - Pending Review Marissa Gago 32 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/20/19,Last post 12/23/19Is there a location within the master account admin to see a list of all forms associated with our Smartsheet account? We need to make a master table of contents (in Smartsheet) so that our internal employees have access to all company Sma…Formulas and Functions323Marissa Gago
