Formulas

Discussion List

  • Help with Trend Data
    In Formulas and Functions
    I need some help with collecting data for trending.  Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet.  On this roll-up sheet I have data that is calculated from the project Status. …
    827 11
    827 views 11 comments Most recent by Andrée Starå Formulas and Functions
  • Formula
    In Formulas and Functions
    I want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column. Unchecked and it shoul…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Mark Cronk Formulas and Functions
  • IF(CHILDREN()) ? - Child inherits parent traits for entire column
    In Formulas and Functions
    I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single…
    Answered - Pending Review
    31 4
    Answered - Pending Review 31 views 4 comments Most recent by Laura K Formulas and Functions
  • Update Sheet 1, Based on Submission to Sheet 2
    In Formulas and Functions
    I have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1…
    Answered - Pending Review
    15 4
    Answered - Pending Review 15 views 4 comments Most recent by Mike Rini Formulas and Functions
  • CountIf with Date range
    In Formulas and Functions
    I am trying to count the number of requests types between a date range.  This is what I thought would work:   =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
    2886 26
    2.9K views 26 comments Most recent by Amy Shank Formulas and Functions
  • Formula
    In Formulas and Functions
    Having difficulty with a formula setting task state (Not Started, In Progress, Complete, On Hold) depending upon how the columns on either side are set - Status/RYGB and % Complete. =IF(AND([email protected]=“B”, [% Complete]@row =1),"Compl…
    Accepted
    20 3
    Accepted Answer 20 views 3 comments Most recent by Bassam.M Khalil Formulas and Functions
  • Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?
    In Formulas and Functions
    I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • NETWORKDAYS Concern With Future and Past Dates
    In Formulas and Functions
    Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper c…
    Unanswered
    13 0
    Question 13 views 0 comments Started by Taylor Compton - NOAA Federal Formulas and Functions
  • Vlookup functions not working on a Master Spreadsheet
    In Using Smartsheet
    My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by SPO MPD Using Smartsheet
  • Weeks to Date Formula- Revision Needed
    In Formulas and Functions
    Hi All, I am currently using the following formula to calculate the weeks until my project delivery date. =INT(([Due Date]@row - TODAY()) /7)) We deliver the project on Tuesday and count that week as week 0. How can I modify this formula…
    Accepted
    13 3
    Accepted Answer 13 views 3 comments Most recent by Heather D Formulas and Functions