Formulas and Functions

Formulas and Functions

Discussion List

  • Alisia Gill
    SUM and SUMIF FormulaAnswered Question
    Answered Alisia Gill 11 views 3 comments Most recent by Andrée Starå
    First post 03/19/20,Last post 03/20/20
    Can anyone help me. I have multiple offices located in different regions (Central, Northwest, Northeast). I need to get the sum of patients seen in each region and place into a dashboard. Example: Central has 4 offices;1 office saw 5 pati…
    Formulas and Functions113
    Alisia Gill
  • Gunn_Jack
    Accepted Answer Gunn_Jack 19 views 3 comments Most recent by Andrée Starå
    First post 03/18/20,Last post 03/20/20
    Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates…
    Formulas and Functions193
    Gunn_Jack
  • Kalifa Telintelo
    First post 03/20/20,Last post 03/20/20
    Hi, I have a column that has a multi select for resource areas needed (multiple functions could be selected). I would like it to then alert a specific person if their area was selected as a need. When I tried to set up an alert and select…
    Formulas and Functions112
    Kalifa Telintelo
  • khankoff
    Answered khankoff 16 views 1 comment Most recent by Frank Falco
    First post 03/19/20,Last post 03/20/20
    I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DMP". I know how to write tha…
    Formulas and Functions161
    khankoff
  • Shannon C Connor
    Answered Shannon C Connor 15 views 1 comment Most recent by Frank Falco
    First post 03/19/20,Last post 03/20/20
    https://us.v-cdn.net/6031209/uploads/907/VW0UK3VB2SUI.png What is the formula if I want to sum only the numbers that don't have a box checked in their row? At the bottom of this screenshot, the $9,000 should return a sum of $6500.
    Formulas and Functions151
    Shannon C Connor
  • System
    Status Balls & Date formulaAnswered Question
    Answered System 18 views 4 comments Most recent by Genevieve P
    First post 03/09/20,Last post 03/19/20
    This discussion was created from comments split from: Help with IF formula.
    Formulas and Functions184
    System
  • M. David
    Accepted Answer M. David 23 views 3 comments Most recent by Paul Newcome
    First post 03/17/20,Last post 03/19/20
    I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assess…
    Formulas and Functions233
    M. David
  • JC Mejia
    Help with Health ColumnAccepted Answer
    Accepted Answer JC Mejia 18 views 2 comments Most recent by JC Mejia
    First post 03/19/20,Last post 03/19/20
    Hello, I need help creating a formula for the health column. Here is what im trying to do: If due date is 2 days or more away: Green =IF([Due Date]@row > TODAY(1), "Green") If due date is day before or day of: Yellow =IF(OR…
    Formulas and Functions182
    JC Mejia
  • Maricarmen
    Accepted Answer Maricarmen 31 views 19 comments Most recent by Paul Newcome
    First post 03/17/20,Last post 03/19/20
    Hello! Creating a sheet to help with Accounts Payable process to external providers. External providers will submit their invoice and payment details into a form that feeds into this sheet. Would like the formula to determine when that in…
    Formulas and Functions3119
    Maricarmen
  • jcismesia76271
    Accepted Answer jcismesia76271 42 views 8 comments Most recent by Genevieve P
    First post 02/14/20,Last post 03/19/20
    Hello - receiving an"unparseable" error for the following sheet summary formula which does a summary looking at 3 different columns - Sub-LOB, ELEMENT and Status. The Sub-LOB and ELEMENT Columns are multi select dropdown column…
    Formulas and Functions428
    jcismesia76271
  • Emma S
    Emma S 26 views 2 comments Most recent by mgibson81
    First post 04/25/18,Last post 03/19/20
    Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-fill…
    Formulas and Functions262
    Emma S
  • Sean Murphy
    Equation helpAccepted Answer
    Accepted Answer Sean Murphy 21 views 16 comments Most recent by Paul Newcome
    First post 03/18/20,Last post 03/19/20
    Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different ste…
    Formulas and Functions2116
    Sean Murphy
  • dakissee108951
    Average formula questionAnswered Question
    Answered dakissee108951 17 views 3 comments Most recent by Paul Newcome
    First post 03/18/20,Last post 03/19/20
    I have a sheet that I need the average formula broken down by person. There are three different people scoring the applicant and I need to average the applicant scores. The formula I have entered is scoring the entire column.
    Formulas and Functions173
    dakissee108951
  • mwiggins
    Accepted Answer mwiggins 30 views 3 comments Most recent by Genevieve P
    First post 02/11/20,Last post 03/19/20
    Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry Ideas?
    Formulas and Functions303
    mwiggins
  • Leann Gibson
    Adding people to GroupsAnswered Question
    Answered Leann Gibson 134 views 9 comments Most recent by Genevieve P
    First post 01/16/20,Last post 03/19/20
    Does anyone know why I am getting this message "Cannot add this user to this group"? I created the group, however it is not letting me add everyone I need to.
    Formulas and Functions1349
    Leann Gibson
  • Scott Verduin
    Answered Scott Verduin 11 views 1 comment Most recent by Andrée Starå
    First post 03/19/20,Last post 03/19/20
    Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's ave…
    Formulas and Functions111
    Scott Verduin
  • Courtney Loukusa
    Accepted Answer Courtney Loukusa 29 views 4 comments Most recent by Andrée Starå
    First post 03/17/20,Last post 03/18/20
    Hello! I'm trying to calculate my savings year-to-date. I thought i had the formula, but soon realized that having blank dates (maybe we don't have a start selling date, or the project is still in development), it'll still return a valu…
    Formulas and Functions294
    Courtney Loukusa
  • xav
    Accepted Answer xav 20 views 4 comments Most recent by Andrée Starå
    First post 03/17/20,Last post 03/18/20
    Hi everybody I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet. The only approach I can think of is…
    Formulas and Functions204
    xav
  • Vidal Castaneda
    Answered Vidal Castaneda 19 views 1 comment Most recent by Paul Newcome
    First post 03/18/20,Last post 03/18/20
    Hello, How can I add an =Formula that would update based on a source SmartSheet? What I need to do is. We update a status of a project on a seperate Master SmartSheet for tracking. The individual Project SmartSheet needs to pull in the…
    Formulas and Functions191
    Vidal Castaneda
  • Kasey Bernard
    Answered Kasey Bernard 23 views 1 comment Most recent by Alejandra
    First post 03/18/20,Last post 03/18/20
    I'm trying to get my countif statements to work. I need to count multiple dept IDs in one column, and pulling information from multiple sheets into one dashboard. In one column, the countif statement IS working and returning a calculated n…
    Formulas and Functions231
    Kasey Bernard
  • jpagan03101416
    Accepted Answer jpagan03101416 15 views 5 comments Most recent by Genevieve P
    First post 03/16/20,Last post 03/18/20
    I have a list of Column 4 = String values Column 3 = Formula ( =COUNTIF({Reference}, [Cell]1) The list of string values is 295 wich will make 590 Cells (Column 4+Column3) to analyze for a pie chart would that be a problem?? because the c…
    Formulas and Functions155
    jpagan03101416
  • Sborror
    Answered Sborror 15 views 6 comments Most recent by Paul Newcome
    First post 03/17/20,Last post 03/18/20
    I have Contact list - multiple resources can be assigned task I want to count the number of times a particular resource has been assigned a task. I've tried these both: =COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actio…
    Formulas and Functions156
    Sborror
  • Paul Newcome
    Paul Newcome 25 views 8 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 03/18/20
    So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentif…
    Formulas and Functions258
    Paul Newcome
  • Kristina Kazakoff
    Accepted Answer Kristina Kazakoff 14 views 13 comments Most recent by Paul Newcome
    First post 03/17/20,Last post 03/18/20
    I'm having trouble with a countifs formula that I tried to find an answer for, but I'm still getting an error. Any help would be greatly appreciated! I'm looking to count the number of MRCU admissions within the month of February: https://…
    Formulas and Functions1413
    Kristina Kazakoff
  • Thimmo Borger
    Answered Thimmo Borger 55 views 1 comment Most recent by Eric M Oliveira
    First post 03/11/20,Last post 03/18/20
    Dear community, I currently need to track budgets for several projects which are linked to certain milestones. To simplify it a lot , there are two Smartsheets. 1st Smartsheet - Contains all projects with a monthly budget. E.g. Project X …
    Formulas and Functions551
    Thimmo Borger
  • Julie B
    Repetitive taskAnswered Question
    Answered Julie B 13 views 1 comment Most recent by Paul Newcome
    First post 03/17/20,Last post 03/17/20
    Hi, Is there a way to show a repetitive task on the same row? See picture attached. Thanks! https://us.v-cdn.net/6031209/uploads/980/MZ6CLANBHQHE.jpg
    Formulas and Functions131
    Julie B
  • Yashwant Singh
    First post 03/17/20,Last post 03/17/20
    hi... I hv created alert someone workflows.. when auto mail send to respected users, sending mail body and contents are not looking in well format.. data is not in table format and blow contents also appearing in last.. You are receiving …
    Formulas and Functions223
    Yashwant Singh
  • Nataleigh
    Answered Nataleigh 141 views 9 comments Most recent by Andrée Starå
    First post 09/27/19,Last post 03/17/20
    I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is cr…
    Formulas and Functions1419
    Nataleigh
  • An Nguyen
    Accepted Answer An Nguyen 23 views 3 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 03/17/20
    Hi everyone, I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my supervisor to use, but I have been str…
    Formulas and Functions233
    An Nguyen