Formulas and Functions

Formulas and Functions

Discussion List

  • Tamara
    Answered - Pending Review Tamara 43 views 13 comments Most recent by Paul Newcome
    First post 05/03/20,Last post 05/15/20
    I am looking to create a count formula that counts only the Children and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula, =COUNTIF(CHILDREN(), 0…
    Formulas and Functions4313
    Tamara
  • MCorbin
    Accepted Answer MCorbin 29 views 3 comments Most recent by Paul Newcome
    First post 05/15/20,Last post 05/15/20
    Not sure if this is possible, but if it is, this group would know! I'm trying to lookup from my Requesting Department Column, which is a multi-select column, to another sheet that has the department head for each department, so that I can…
    Formulas and Functions293
    MCorbin
  • L@123
    [email protected] 18 views 0 comments Started by [email protected]
    First post 05/15/20,Last post 05/15/20
    I would like to be able to append/adjust actively sorted values in a range. In other words to be able to handle data more like matrix formulas in excel. Currently this is done with collect, but there isn't a way to change the values being …
    Formulas and Functions180
    [email protected]
  • kari1282
    Answered - Pending Review kari1282 20 views 1 comment Most recent by Paul Newcome
    First post 05/15/20,Last post 05/15/20
    I have a form where people submit there email is there a way to automatically change this to a contact list. Thank you Karrie
    Formulas and Functions201
    kari1282
  • Petra Stewart
    Answered - Pending Review Petra Stewart 17 views 2 comments Most recent by lauren.waters111676
    First post 04/14/20,Last post 05/15/20
    Hi, Is it possible to enter a hyperlink to an external email (eg. client, who does NOT have access to the SmartSheet)? We would like to have this in order to be able to write email to a client by just clicking at is email within our Smart…
    Formulas and Functions172
    Petra Stewart
  • Lasse Dupont
    Answered - Pending Review Lasse Dupont 7 views 5 comments Most recent by Paul Newcome
    First post 05/15/20,Last post 05/15/20
    Hi Community I am trying to output only workdays so not Saturdays and Sundays. On a second note I have a sheet called Holidays with specific holidays I need to exclude in the same formula, via reference another sheet. The holiday sheet is…
    Formulas and Functions75
    Lasse Dupont
  • Yeshaya
    Answered - Pending Review Yeshaya 17 views 5 comments Most recent by Paul Newcome
    First post 05/14/20,Last post 05/15/20
     Perhaps you can help me with the creation of the formula. I will paste what I have done so far but it is giving me an error. =IF(VIN137 = {TOPSHEETS - Leasing Direct Range 1} {TOPSHEETS - Leasing Direct Range 3}>5/14/2020, {TOPSHEETS -…
    Formulas and Functions175
    Yeshaya
  • Kelly Parker
    Answered - Pending Review Kelly Parker 10 views 1 comment Most recent by Andrée Starå
    First post 05/15/20,Last post 05/15/20
    I am trying to create a test / exam / assessment in SS and create a formula to auto grade automatically. I created a column for the answer and a column to indicate if each column question is correct. The problem is when the user completes …
    Formulas and Functions101
    Kelly Parker
  • Kristina Kazakoff
    Accepted Answer Kristina Kazakoff 15 views 3 comments Most recent by Paul Newcome
    First post 05/14/20,Last post 05/15/20
    I need some help with these netdays formulas. I'm struggling with the best solution for excluding the blanks in the Date of Dis-enrollment column. https://us.v-cdn.net/6031209/uploads/139/K1R77E3P3LAC.png I have the netdays formula applied…
    Formulas and Functions153
    Kristina Kazakoff
  • Penny Wilson
    Answered - Pending Review Penny Wilson 20 views 1 comment Most recent by Paul Newcome
    First post 05/14/20,Last post 05/15/20
    I have a column in my sheet that is the system Modified (Date) date and time. I need to know the latest date and time in that column because sometimes the date is the same but the time is different. MAX only works with the date part. Ca…
    Formulas and Functions201
    Penny Wilson
  • Benjo09
    Answered - Pending Review Benjo09 17 views 1 comment Most recent by Andrée Starå
    First post 05/14/20,Last post 05/15/20
    hi, I have a work approval request flow that being used to our department for document approval process. We have one manager who accidentally deleted the approval request email and we don't know how to retrieved it since it was gone in to …
    Formulas and Functions171
    Benjo09
  • CRL Planning
    Answered - Pending Review CRL Planning 65 views 6 comments Most recent by Andrée Starå
    First post 03/07/20,Last post 05/15/20
    I have a number of sheets that are fed data via forms. The sheets are setup to deal with this incoming data automatically and they feed selected information to Dashboards via reports and formulas that run within the sheets. The problem I h…
    Formulas and Functions656
    CRL Planning
  • Anne VanCuren
    Accepted Answer Anne VanCuren 39 views 1 comment Most recent by Mary_A
    First post 05/14/20,Last post 05/15/20
    I need to count the items in Column 7 that contain "OR" or "P". I can count them individually, but can't figure out where the OR part needs to go to get both factors in the count. =COUNTIF([Column7]2:[Column7]7, CONTAI…
    Formulas and Functions391
    Anne VanCuren
  • Jason Clark
    Answered - Pending Review Jason Clark 15 views 2 comments Most recent by Jason Clark
    First post 05/13/20,Last post 05/14/20
    I have a stock sheet. Rows are the stock items. I have 10 columns that represent orders coming in. i have a due date at the top of each column (treated as text) with the quantity of each the items below. I want to build a Sum IF formula to…
    Formulas and Functions152
    Jason Clark
  • Alessandro Terranova
    Answered - Pending Review Alessandro Terranova 31 views 3 comments Most recent by Andrée Starå
    First post 04/30/20,Last post 05/14/20
    Hi Community, I have a master Intake sheet fed by an intake form, this serves the purposes of multiple departments. I would like to create a second sheet that automatically receives data from the primary intake sheet that only captures th…
    Formulas and Functions313
    Alessandro Terranova
  • Cuatro
    Cuatro 56 views 16 comments Most recent by Andrée Starå
    First post 07/15/19,Last post 05/14/20
    I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change. For example: If I change the status of "Software" to Red (R) in the child row, it…
    Formulas and Functions5616
    Cuatro
  • Susan B Peck
    Accepted Answer Susan B Peck 14 views 3 comments Most recent by Andrée Starå
    First post 05/06/20,Last post 05/14/20
    Hi, We have some scheduling sheets with a set of tasks (deliverables) for each project. Each task has a checkbox to tell the team whether that deliverable is required for that project. If the checkbox is empty, cells in the row are fille…
    Formulas and Functions143
    Susan B Peck
  • Cindy Bowker
    Accepted Answer Cindy Bowker 14 views 6 comments Most recent by Andrée Starå
    First post 04/27/20,Last post 05/14/20
    I have accidentally deleted one of my formulas and can't get it working again. Please help. I need to do a vlookup but I keep getting a no match error =VLOOKUP(Project1, {Project Ref Number}, 1, false) this is my formula, not sure what the…
    Formulas and Functions146
    Cindy Bowker
  • Tammy Parker
    Answered - Pending Review Tammy Parker 24 views 9 comments Most recent by Andrée Starå
    First post 04/23/20,Last post 05/14/20
    I have a completed column with a check box. When that box is checked, I would like the Date Completed box to auto populate with Todays date. Is that possible? I tried =IF(Complete1 = 1,TODAY(),"")) but that does not work... ugh
    Formulas and Functions249
    Tammy Parker
  • Himanshu Agarwal
    Answered - Pending Review Himanshu Agarwal 64 views 15 comments Most recent by Andrée Starå
    First post 04/09/20,Last post 05/14/20
    Dataset: https://us.v-cdn.net/6031209/uploads/773/T3VHWMIZ1NJC.png Required Output: https://us.v-cdn.net/6031209/uploads/317/7FFDDOXV39O6.png I am trying to extract data from the rows which have its first column starting with particular co…
    Formulas and Functions6415
    Himanshu Agarwal
  • Julie Barbeau
    Answered - Pending Review Julie Barbeau 11 views 1 comment Most recent by Andrée Starå
    First post 05/14/20,Last post 05/14/20
    Hi, Conditions That Trigger Formula Autofill You’ll see formulas populate automatically when you type in a newly inserted or blank row that is: Directly between two others that contain the same formula in adjacent cells. In my example bel…
    Formulas and Functions111
    Julie Barbeau
  • Emmet McKenna
    Answered - Pending Review Emmet McKenna 24 views 1 comment Most recent by Andrée Starå
    First post 05/14/20,Last post 05/14/20
    Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already …
    Formulas and Functions241
    Emmet McKenna
  • Philip Hanekom
    Accepted Answer Philip Hanekom 14 views 6 comments Most recent by Andrée Starå
    First post 04/20/20,Last post 05/14/20
    Hi, I have a user populated field (using a dropdown) where the options range from “1-Innocence” to “5-Excellence” – this makes more sense to a user than simply having a 1-5 available for selection. To summarise these ratings per theme, foc…
    Formulas and Functions146
    Philip Hanekom
  • Anil Rattan
    Answered - Pending Review Anil Rattan 6 views 1 comment Most recent by [email protected]
    First post 05/14/20,Last post 05/14/20
    Hi, I have one Smart-sheet A with all the details. One of the column is Date. I created an another Smart sheet B where I have all the formulas. On of the formula I am using is =ROUNDUP(MONTH({QMS GAP Analysis Range 9}, 2)) As each cell in…
    Formulas and Functions61
    Anil Rattan
  • Jana Brits
    Answered - Pending Review Jana Brits 15 views 3 comments Most recent by Andrée Starå
    First post 04/30/20,Last post 05/14/20
    I have a sheet with an automatic numbering column. Data for this sheet will be captured through a webform. I need certain columns, which will not be populated throught the webform, to have formulas in them. How do I add those formulas with…
    Formulas and Functions153
    Jana Brits
  • Laura_Murphy
    Flag FormulaQuestion
    Answered - Pending Review Laura_Murphy 17 views 15 comments Most recent by Andrée Starå
    First post 05/11/20,Last post 05/14/20
    Hello I would like to make the flag red if 2 criteria are met % Column is under 80% AND Deadline is within the next 2 days? IF(AND(% Column)@row), <80%, (Deadline)? I'm stuck on the second half of the formula can anyone help? Many th…
    Formulas and Functions1715
    Laura_Murphy
  • Sborror
    Answered - Pending Review Sborror 15 views 3 comments Most recent by Andrée Starå
    First post 05/06/20,Last post 05/14/20
    I have email addresses that are wrong in the automation. My contact list is defined and only is accepting the prescribed values. I would like to remove the ones from the automation if possible so folks don't inadvertently select the wrong …
    Formulas and Functions153
    Sborror
  • Diana Chamberlain
    Accepted Answer Diana Chamberlain 27 views 4 comments Most recent by Paul Newcome
    First post 05/01/20,Last post 05/14/20
    Hello! I am trying to create a formula which counts all items that are NOT assigned to a list of about 8 people. These will be totaled into an "Other" field. Example: PMs include Bob, Sarah, Dee, David, and George. I have count…
    Formulas and Functions274
    Diana Chamberlain
  • Stacey Perry
    Answered - Pending Review Stacey Perry 17 views 2 comments Most recent by Stacey Perry
    First post 05/14/20,Last post 05/14/20
    Is there a feature that would allow a SmartSheet form to automatically re-open with a new form after hitting submit? we are using a form for each caller and it is cumbersome to hit submit and then find/click the link to open a new form.
    Formulas and Functions172
    Stacey Perry
  • Molly Coop
    Accepted Answer Molly Coop 23 views 3 comments Most recent by Paul Newcome
    First post 05/13/20,Last post 05/14/20
    I have the need to calculate the amount of days a record was open or is currently open. I keep getting errors in the formula. I have the below screen shot for reference. So, when Progress tracking = complete I need the networkdays from…
    Formulas and Functions233
    Molly Coop