Formulas and Functions
Archives for December 2019
Discussion List
-
SUMIF Halp!Accepted AnswerAccepted Answer ryan.diamond55371 33 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 Functions339ryan.diamond55371
-
Answered 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 13 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 Functions133dakissee108951
-
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 Functions356wabel 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 Functions665coryg
-
How do I sum up the last two characters of a cell?Accepted AnswerAccepted Answer SuzanneH 12 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 Functions123SuzanneH
-
Summing a columnAnswered QuestionFirst 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 Functions373SuzanneH
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow StaAnswered QuestionAnswered 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 43 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 Functions4310SuzanneH
-
General questions about setting up company projectsAnswered QuestionFirst 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 66 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 Functions6613Rene Montijn -
Date Automation Between Two Sheets?Answered QuestionFirst 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 Functions424jlheaney
-
SUMIFs not working in Smartsheet VS ExcelAccepted AnswerAccepted Answer Jia Lee 34 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 https://us.v-cdn.net/6031209/uploads/878/WXQTOPGMJJ7A.png 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 …Formulas and Functions345Jia Lee
-
I need help bucketing some dataAccepted AnswerAccepted Answer Brian Erdelyi 32 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 Functions323Brian Erdelyi -
Auto Date CalculationAccepted AnswerAccepted Answer Paul Raphael 45 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 Functions457Paul Raphael
-
Countif formula for specific criteriaAnswered QuestionFirst 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 Functions361JennS_
-
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 Functions401Michael 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 33 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). https://us.v-cdn.net/6031209/uploads/344/N2FAWB56MH5R.pngFormulas and Functions333Bengs
-
Accepted Answer FusiaSuede 38 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 Functions383FusiaSuede
-
Multiple IF function pull from multiple cellsAccepted AnswerAccepted Answer Jasmine Brown 52 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 Functions526Jasmine Brown
-
Apostrophe Added to FormulaAccepted AnswerAccepted Answer Sue Crawford (admin) 33 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 Functions334Sue Crawford (admin)
-
Accepted Answer Chris White 42 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 Functions424Chris White
-
#INVALID OPERATION in my nested IF statementAnswered QuestionAnswered Rebekah Pound 48 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 Functions484Rebekah Pound
-
MULTIPLE LINE (CHILDREN) IN ONE FORMAnswered QuestionAnswered Mariniel Bautista 38 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 Functions382Mariniel Bautista -
Automated Printing of a Dashboard - or workaround to take a snapshot before month carries overAnswered QuestionAnswered SammyMorey 47 views 3 comments 0 points Most recent by Jose Manuel Montemayor Formulas and FunctionsFirst post 12/23/19,Last post 01/05/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 Functions473SammyMorey
-
Parent Child NumberingAccepted AnswerAccepted Answer Stavros_McGillicuddy 84 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 Functions8411Stavros_McGillicuddy
-
Adding to a Complex FormulaAccepted AnswerAccepted Answer Ray B 32 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 Functions3213Ray B
-
Can you use sheet summary fields across sheets?Answered QuestionAnswered Terri Pavlovic 45 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 Functions451Terri Pavlovic
-
List of All Forms Associated with an AccountAnswered QuestionAnswered Marissa Gago 25 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 Functions253Marissa Gago
