Formulas and Functions

Formulas and Functions

Discussion List

  • steve50951
    steve50951 29 views 17 comments Most recent by steve50951
    First post 03/23/20,Last post 03/25/20
    I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to ch…
    Formulas and Functions2917
    steve50951
  • Tomas Giele
    Answered Tomas Giele 13 views 1 comment Most recent by Paul Newcome
    First post 03/25/20,Last post 03/25/20
    Dear Mr/ Ms, I'm looking for ways to organize document control in Smartsheet through check boxes if/when documents are revised by colleagues. I'm looking for a way to 'check' a box, and then in another collumn(s) report who checked the bo…
    Formulas and Functions131
    Tomas Giele
  • Daniel Child
    Nested if for FLAG columnAccepted Answer
    Accepted Answer Daniel Child 23 views 2 comments Most recent by Andrée Starå
    First post 03/24/20,Last post 03/25/20
    I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
    Formulas and Functions232
    Daniel Child
  • SuzanneH
    Accepted Answer SuzanneH 39 views 10 comments Most recent by Andrée Starå
    First post 12/30/19,Last post 03/25/20
    I 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 Functions3910
    SuzanneH
  • siouxzie7
    Answered siouxzie7 34 views 4 comments Most recent by Andrée Starå
    First post 02/12/20,Last post 03/25/20
    I have a parent cell that should be looking at its children for a value, and if it finds that value in any of the children, it should display that value in itself, else nothing. This seems pretty straight forward, but it's not working. It …
    Formulas and Functions344
    siouxzie7
  • Shawn Borror
    Answered Shawn Borror 15 views 3 comments Most recent by Andrée Starå
    First post 02/11/20,Last post 03/25/20
    Is there an ability to allow not SS users the ability to update their assigned data elements on demand or does it have to be done via a workflow that runs on time based? Many legal team members need to update on demand for legal 'tickets'…
    Formulas and Functions153
    Shawn Borror
  • Amy Arnold
    Answered Amy Arnold 35 views 7 comments Most recent by Andrée Starå
    First post 03/21/20,Last post 03/25/20
    Hi, I created a form to collect survey results, the responses are returned to Smartsheet #1 (image below). The survey has 18 questions with these dropdown (single select) responses: Good Satisfactory Does Not Meet Standards Not applicable…
    Formulas and Functions357
    Amy Arnold
  • Mitchell Moses
    Accepted Answer Mitchell Moses 11 views 1 comment Most recent by Andrée Starå
    First post 03/25/20,Last post 03/25/20
    I want to sum numbers in a column of all the vendors. If I filter out certain vendors I want the sum to be only of the vendors showing. How do I do that?
    Formulas and Functions111
    Mitchell Moses
  • AJ King
    CountIF but not blanksAccepted Answer
    Accepted Answer AJ King 25 views 5 comments Most recent by Paul Newcome
    First post 03/19/20,Last post 03/24/20
    Hi everyone - sorry if this has already been asked and answered. But, i am trying to have a box checked if there is a duplicate entry. This is the formula i am using: =IF(COUNTIF([FA Peoplesoft ID]:[FA Peoplesoft ID], [FA Peoplesoft ID]@r…
    Formulas and Functions255
    AJ King
  • Shirley Vue
    Trying to find value textAnswered Question
    Answered Shirley Vue 10 views 5 comments Most recent by Paul Newcome
    First post 03/24/20,Last post 03/24/20
    I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @c…
    Formulas and Functions105
    Shirley Vue
  • Danielle Arteaga
    Answered Danielle Arteaga 13 views 4 comments Most recent by Danielle Arteaga
    First post 03/24/20,Last post 03/24/20
    I have a sheet that has rows added through an automated background process (not a form). As the rows come in, they are assigned a date in a column called "Date of Inquiry." There are two other pertinent columns in the sheet: a H…
    Formulas and Functions134
    Danielle Arteaga
  • Jeremy Klingensmith
    Need FormulaAccepted Answer
    Accepted Answer Jeremy Klingensmith 23 views 5 comments Most recent by Paul Newcome
    First post 03/23/20,Last post 03/24/20
    I need a formula that will raise the flag when the following conditions are met: -If Status reads "Not Started" or "Complete" AND -If Start Date is less than TODAY
    Formulas and Functions235
    Jeremy Klingensmith
  • Stephen Wood
    Accepted Answer Stephen Wood 16 views 4 comments Most recent by Stephen Wood
    First post 03/24/20,Last post 03/24/20
    This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
    Formulas and Functions164
    Stephen Wood
  • Chichi
    Time-tracker formulaAnswered Question
    Answered Chichi 25 views 6 comments Most recent by Paul Newcome
    First post 03/24/20,Last post 03/24/20
    Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1 When I …
    Formulas and Functions256
    Chichi
  • Chichi
    Send Update RequestsAnswered Question
    Answered Chichi 11 views 6 comments Most recent by Chichi
    First post 03/24/20,Last post 03/24/20
    I deleted an automated "Send Update Requests" that I set up but for some reason it is still sending notifications to people. How can I undo that even tho I can't see where its coming from
    Formulas and Functions116
    Chichi
  • Tiffany Sherrane
    Answered Tiffany Sherrane 11 views 1 comment Most recent by Paul Newcome
    First post 03/24/20,Last post 03/24/20
    Similarly to a running total, I am needing to have  a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?
    Formulas and Functions111
    Tiffany Sherrane
  • Jen Tankersley
    Sum of column YTDAccepted Answer
    Accepted Answer Jen Tankersley 15 views 3 comments Most recent by Paul Newcome
    First post 03/24/20,Last post 03/24/20
    I am not a pro with formulas, but I have been able to figure out most of the formulas I need by perusing this community. However, this formula comes up #unparseable with everything I do. Can someone help me spot what I'm doing wrong? =SU…
    Formulas and Functions153
    Jen Tankersley
  • Jacques Hollands
    Calculating Fuel ConsumptionAnswered Question
    Answered Jacques Hollands 32 views 8 comments Most recent by Rainier Hollands
    First post 03/23/20,Last post 03/24/20
    Hi there, I manage a transport fleet and want to use Smartsheet to track the vehicles' fuel consumption. It is calculated by subtracting the kilometres from the previous fill-up from the current fill and dividing this variance by the litre…
    Formulas and Functions328
    Jacques Hollands
  • Rainier Hollands
    Rainier Hollands 32 views 4 comments Most recent by Rainier Hollands
    First post 03/24/20,Last post 03/24/20
    Hi guys I need help writing a formula. I'm trying to write a formula in which it calculates the fuel consumption for each truck for that specific date. What I was trying to say with the formula is that it should look at which truck, date a…
    Formulas and Functions324
    Rainier Hollands
  • Sean Murphy
    Count if by dateAccepted Answer
    Accepted Answer Sean Murphy 15 views 5 comments Most recent by Paul Newcome
    First post 03/24/20,Last post 03/24/20
    @Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm just counting and manually adding it to…
    Formulas and Functions155
    Sean Murphy
  • cthrasher97141
    Answered cthrasher97141 53 views 5 comments Most recent by Paul Newcome
    First post 01/08/20,Last post 03/24/20
    Hello I would like to add multiple contacts to a single contact cell for one task with a formula, is there a away to do this? Can Group Management be utilized? Thank you
    Formulas and Functions535
    cthrasher97141
  • Usha Pillai
    ReportingAccepted Answer
    Accepted Answer Usha Pillai 15 views 4 comments Most recent by Paul Newcome
    First post 03/23/20,Last post 03/24/20
    Hello, I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However, the formula does not check parent row…
    Formulas and Functions154
    Usha Pillai
  • Stavros_McGillicuddy
    Parent Child NumberingAccepted Answer
    Accepted Answer Stavros_McGillicuddy 80 views 11 comments Most recent by Stavros_McGillicuddy
    First post 12/21/19,Last post 03/23/20
    With 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 Functions8011
    Stavros_McGillicuddy
  • Angela
    Answered Angela 16 views 1 comment Most recent by Paul Newcome
    First post 03/23/20,Last post 03/23/20
    I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can someone help me please. Can this be accomp…
    Formulas and Functions161
    Angela
  • Gaeli
    Accepted Answer Gaeli 17 views 3 comments Most recent by Gaeli
    First post 03/23/20,Last post 03/23/20
    In the CountM Article is states you can collect a total number however I would like a count of Specific Items. For example how many Pears? How many Apples? Is that possible?
    Formulas and Functions173
    Gaeli
  • Rachel Heard
    Accepted Answer Rachel Heard 22 views 5 comments Most recent by Paul Newcome
    First post 03/19/20,Last post 03/23/20
    I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word…
    Formulas and Functions225
    Rachel Heard
  • Liam Burnett
    Accepted Answer Liam Burnett 33 views 12 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/23/20
    Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way to do this without the dates being in …
    Formulas and Functions3312
    Liam Burnett
  • April Tucker
    Accepted Answer April Tucker 21 views 12 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/23/20
    Hi - I'm trying to automate the At Risk flag to change to RED 72 hours prior to the task deadline so it can trigger an email to the person assigned to the task. I have created the workflow/alert email upon red flag trigger, so that part i…
    Formulas and Functions2112
    April Tucker
  • RySols
    RySols 244 views 15 comments Most recent by Paul Newcome
    First post 12/04/19,Last post 03/23/20
    Hi All,  I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
    Formulas and Functions24415
    RySols
  • taylor.thompson89836
    If(And(OrAccepted Answer
    Accepted Answer taylor.thompson89836 25 views 29 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/23/20
    I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equal…
    Formulas and Functions2529
    taylor.thompson89836