Formulas and Functions

Formulas and Functions

Discussion List

  • ginamt3
    Answered - Pending Review ginamt3 19 views 3 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/02/20
    I want to be able to Count the yellow parent weeks to say how many weeks out from current week is. For example week of 6/28 is current week. I want the proceeding weeks to say for example 7/12/20 - 3 weeks out 7/19/20 4 weeks out The curr…
    Formulas and Functions193
    ginamt3
  • Damon Lloyd
    IF(AND's and IF(OR'sAccepted Answer
    Accepted Answer Damon Lloyd 14 views 3 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/02/20
    I have the below formula working to assign a price pursuant to particular job's complexity. =IF(COMPLEXITY517 = "LOW", 1000, IF(COMPLEXITY517 = "MID", 1500, IF(COMPLEXITY517 = "HIGH", 2000, IF(COMPLEXITY517 = …
    Formulas and Functions143
    Damon Lloyd
  • Peggy
    Peggy 9 views 1 comment Most recent by Genevieve P
    First post 06/30/20,Last post 07/02/20
    Hi, I have this formula that i have written. It works fine, but I am getting blank fields, when I was expecting N/A. The product line row has EBS, JDE, SAP. The TLR Scope is Financials, HR, Payroll For EBS I want values returned and N/A f…
    Formulas and Functions91
    Peggy
  • Brian_Anderson_Vegas
    Graphing DataAccepted Answer
    Accepted Answer Brian_Anderson_Vegas 16 views 3 comments Most recent by Genevieve P
    First post 06/26/20,Last post 07/02/20
    PROBLEM 1 Is there a way, then graphing data from a sheet to have it automatically pull in the data into a graph when new rows are added? Currently, I click the graph widget on the Dashboard, and select the data I want to graph - but when…
    Formulas and Functions163
    Brian_Anderson_Vegas
  • Amy Evans
    NESTED IF STATEMENTAccepted Answer
    Accepted Answer Amy Evans 30 views 3 comments Most recent by Genevieve P
    First post 06/26/20,Last post 07/02/20
    Hello, What am I doing incorrectly with my formula below? I'm receiving an incorrect argument error. (Image) =IF([Team Number]28 > 0, YEAR(Date3) = "2021", MONTH(Date3), IF([Team Number]28 = 0, YEAR($Date$2) = "2021&qu…
    Formulas and Functions303
    Amy Evans
  • Matt Foss
    Accepted Answer Matt Foss 13 views 3 comments Most recent by Genevieve P
    First post 07/01/20,Last post 07/02/20
    Hello everyone, I am trying to calculate the average of a column based on criteria found in another. The catch is that I don't want to specify the specific text of the other criteria as it is going to be based off of an ever expanding drop…
    Formulas and Functions133
    Matt Foss
  • SammyMorey
    Answered - Pending Review SammyMorey 90 views 5 comments Most recent by SammyMorey
    First post 12/23/19,Last post 07/02/20
    Hey 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 Functions905
    SammyMorey
  • Vickie Lim
    Answered - Pending Review Vickie Lim 22 views 4 comments Most recent by Vickie Lim
    First post 06/29/20,Last post 07/01/20
    Hi there - What is the best way to do a 'count' on a drop down field located at the "summary sheet"? For example: I have a drop down field on summary sheet called "Alignment". It has drop down values such as cost re…
    Formulas and Functions224
    Vickie Lim
  • Kiera3
    Answered - Pending Review Kiera3 18 views 2 comments Most recent by Chris Rea
    First post 07/01/20,Last post 07/01/20
    I am trying to count the items that have a particular workstream, multiple status (blank, In progress) and Due date in the past. here is my formula: =COUNTIFS([Workstream]:[Workstream], @row "QBR", [Status]:[Status], @row "…
    Formulas and Functions182
    Kiera3
  • Lyn Pringle
    Answered - Pending Review Lyn Pringle 19 views 2 comments Most recent by Debbie Sawyer
    First post 06/30/20,Last post 07/01/20
    Hi, We using a Smartsheet form to capture Covid19 Screening Questions. Once submitted the person has their temperature recorded which is manually captured against the record. The problem I am experiencing is that the person capturing the …
    Formulas and Functions192
    Lyn Pringle
  • Stavros_McGillicuddy
    Answered - Pending Review Stavros_McGillicuddy 11 views 1 comment Most recent by Debbie Sawyer
    First post 07/01/20,Last post 07/01/20
    I need to start using sub tasks. I already have hierarchies built into my input sheet. Much of the information on the parent must also be included in the child tasks Is it possible to systemically copy data from a parent task into a sub ta…
    Formulas and Functions111
    Stavros_McGillicuddy
  • Chanee  Batton
    Answered - Pending Review Chanee Batton 23 views 3 comments Most recent by Andrée Starå
    First post 06/29/20,Last post 07/01/20
    I'd love to find Smartsheet consultants that could revamp, update how we currently use it to maximize, utilize the portal function, address automation's, alerts, set up some reporting etc. Not looking for instructions, but teams that imple…
    Formulas and Functions233
    Chanee Batton
  • dsmartsheetuser
    Answered - Pending Review dsmartsheetuser 24 views 3 comments Most recent by Genevieve P
    First post 06/26/20,Last post 07/01/20
    Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1…
    Formulas and Functions243
    dsmartsheetuser
  • System
    Answered - Pending Review System 23 views 2 comments Most recent by Genevieve P
    First post 06/28/20,Last post 07/01/20
    This discussion was created from comments split from: Working with Symbol Formulas.
    Formulas and Functions232
    System
  • Allan Kelsch
    Answered - Pending Review Allan Kelsch 22 views 1 comment Most recent by Paul Newcome
    First post 06/30/20,Last post 07/01/20
    Hello, I am looking to see if there is a way to set up a formula that reads the difference of two columns (start time and end time) and converts to "total hours and minutes". What I am trying to do, is set up a sheet where we ca…
    Formulas and Functions221
    Allan Kelsch
  • Rivky Emert
    Answered - Pending Review Rivky Emert 18 views 2 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/01/20
    Hi Community, I am trying to make a work flow that moves a row when the Latest Claim Status is Denied. However, I only want the row to move once all the columns are filled in for that row. I don't want any specific cell to be the trigger a…
    Formulas and Functions182
    Rivky Emert
  • Prajna Jain
    Answered - Pending Review Prajna Jain 18 views 1 comment Most recent by Paul Newcome
    First post 06/27/20,Last post 07/01/20
    Can any one help on getting a formula to calculate End Date and Time based on Start Date and Time and Allocated hours for a Project considering 8 am to 8 pm working hours and excluding Saturday, Sunday and Holidays?
    Formulas and Functions181
    Prajna Jain
  • Ron Anderson
    Answered - Pending Review Ron Anderson 12 views 1 comment Most recent by Andrée Starå
    First post 07/01/20,Last post 07/01/20
    I am trying to populate a date column with the date that another column is approved. I am befuddled. My formula returns today's date but it changes every day. =IF([BIC Approved]@row = "approved", TODAY())
    Formulas and Functions121
    Ron Anderson
  • Marilen.Navarro103391
    Answered - Pending Review Marilen.Navarro103391 32 views 1 comment Most recent by Genevieve P
    First post 06/27/20,Last post 07/01/20
    Hello, I need to build a sheet summary (report) for all the sum of the table below. I want to show on my Dashboard a Summary of each Status (In Progress etc....for each month... for Jose and Karlo and 5 more not included in my screen captu…
    Formulas and Functions321
    Marilen.Navarro103391
  • Dawn Skirvin
    Accepted Answer Dawn Skirvin 14 views 3 comments Most recent by Genevieve P
    First post 06/29/20,Last post 07/01/20
    =IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),""))) If below/above certain percentages, attempting to change the ball to red/yello…
    Formulas and Functions143
    Dawn Skirvin
  • Shesha_K
    Answered - Pending Review Shesha_K 28 views 1 comment Most recent by Genevieve P
    First post 06/26/20,Last post 07/01/20
    Hello Community, I am hoping someone has a suggestion for my issue. I searched the previously asked questions and couldn't seem to find it. Ultimately, I am trying to maintain one master sheet of data that populates secondary filtered shee…
    Formulas and Functions281
    Shesha_K
  • Brian Becnel
    Accepted Answer Brian Becnel 13 views 2 comments Most recent by Brian Becnel
    First post 07/01/20,Last post 07/01/20
    I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is …
    Formulas and Functions132
    Brian Becnel
  • FreezeBrew
    Answered - Pending Review FreezeBrew 22 views 2 comments Most recent by Genevieve P
    First post 06/26/20,Last post 07/01/20
    Hi, I am working on building construction scheduling. In the template of my schedule, I have a list of items with predecessors. My questions, once I marked one item as N/A or DONE(two separate check boxes), how can I make the following ite…
    Formulas and Functions222
    FreezeBrew
  • Tanya Brooks
    Ad hoc reportingAccepted Answer
    Accepted Answer Tanya Brooks 15 views 3 comments Most recent by Tanya Brooks
    First post 06/29/20,Last post 07/01/20
    In forms or reports is ther a way for user to enter a variable? Situation: Sheet contains thouseands of employee names and corresponding information. Do not want users directly in sheet so they need to update information via report. Is …
    Formulas and Functions153
    Tanya Brooks
  • Jennifer Seymour
    Answered - Pending Review Jennifer Seymour 12 views 1 comment Most recent by Jason Tarpinian
    First post 07/01/20,Last post 07/01/20
    I want to flip a column which will be last, first names and return first last. So Doe, John becomes John Doe I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is no…
    Formulas and Functions121
    Jennifer Seymour
  • Jennifer Seymour
    Answered - Pending Review Jennifer Seymour 12 views 1 comment Most recent by Jason Tarpinian
    First post 07/01/20,Last post 07/01/20
    Is there a way to take a column: Last, First and build [email protected] Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
    Formulas and Functions121
    Jennifer Seymour
  • Elaine Bye
    Answered - Pending Review Elaine Bye 16 views 1 comment Most recent by Genevieve P
    First post 06/30/20,Last post 07/01/20
    I have a report pulling data from multiple sheets. I have the report on a dashboard. I would like to be able to filter the report from the dashboard? Is this possible?
    Formulas and Functions161
    Elaine Bye
  • Rebecca Panaccione
    Accepted Answer Rebecca Panaccione 25 views 3 comments Most recent by Genevieve P
    First post 06/25/20,Last post 07/01/20
    Hello, I have a test master grid sheet where dates of leave (and different types of leave) are collected through a form. Formula used for collecting dates together is: =IF([End Date]@row <= [Start Date]@row, [Start Date]@row + &qu…
    Formulas and Functions253
    Rebecca Panaccione
  • Alessandro Terranova
    Count dropdown and %Accepted Answer
    Accepted Answer Alessandro Terranova 17 views 3 comments Most recent by Paul Newcome
    First post 06/30/20,Last post 07/01/20
    Hi Community, I am defining the following formula to count how many children cells are blank out of the total number of children cells along with the associated percentage value. In a Team schedule sheet this will count how many time slot…
    Formulas and Functions173
    Alessandro Terranova
  • Doyle54
    Answered - Pending Review Doyle54 15 views 9 comments Most recent by Paul Newcome
    First post 06/29/20,Last post 07/01/20
    I am trying to use: CONTAINS(OnePt, @cell), [OnePt]:[OnePt] Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record. If I cannot use the logic, can you explain the scenario and cell in a c…
    Formulas and Functions159
    Doyle54