Formulas and Functions

Archives for April 2021

Discussion List

  • Changing an older cell based on criteria from a newer cell
    In Formulas and Functions
    Hello, Looking for a little assistance with a formula (or workflow), if even at all possible. I have a row of data with a Date, a Room and a Status of “Conditional Pass”. When that same Room gets checked again at a later Date, has a S…
    Accepted
    24 5
    Accepted Answer 24 views 5 comments Most recent by Mark Cronk Formulas and Functions
  • Resolve Multi-Select Choices into single lines
    In Formulas and Functions
    I have about 25 identical project schedule sheets. Each task has a flag indicating if it is a milestone that is also a change event (someone's job is changing). I'd like to create a sheet and calendar of all change events aggregated from a…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Ronald Moyer Formulas and Functions
  • Can I nest more than one SUMIF
    In Formulas and Functions
    I am trying to create a SUMIF that will evaluate three options from drop down column and return a reduced percentage sum from within another column on the same sheet. Drop down Column - Affected Customer Impact Risk Options - Low Impact Ri…
    Answered - Pending Review
    12 5
    Answered - Pending Review 12 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • VLOOKUP on a Multi DropDown List
    In Formulas and Functions
    I'm attempting to setup an asset tracking system using Smartsheets, where individuals fill out a form requesting specific assets, in which they'd be assigned in the sheet using a multi select dropdown of all the asset barcodes. In another …
    Answered - Pending Review
    143 6
    Answered - Pending Review 143 views 6 comments Most recent by Bassam Khalil Formulas and Functions
  • Rozanne Reedy
    In Formulas and Functions
    How do we keep rows from randomly moving down the sheet, usually to the bottom. My team is constantly having to move rows back to the original line. This is occurring whether changes are made to that row or not.
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by Rozanne Reedy Formulas and Functions
  • Count employees starting by a set date
    In Formulas and Functions
    Hello, I am making a dashboard for a staffing tracker. I need to count the number of employees for a given building that will be ready for start by a given date. They should not be counted if they have been disqualified. The start can…
    Accepted
    12 5
    Accepted Answer 12 views 5 comments Most recent by Mark Cronk Formulas and Functions
  • Help with Formula for Budget Spread
    In Formulas and Functions
    Can someone help with creating a formula? We are trying to develop a formula to help create an automatic budget spread/phasing over the year. Sheet Info: We have columns named for the twelve months of the year We have a BUDGET column We ha…
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Index Match
    In Formulas and Functions
    Hello there. I have a column on two separate sheets called Dept Link. If the content of these cells match, I want it to report out the contents of a different cell called Highlights. How would I do that?
    Accepted
    18 3
    Accepted Answer 18 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Symbols don't appear anymore when used in a Formula
    In Formulas and Functions
    Hi, please help me ! Symbols don't appear anymore in columns where there is a formula. It only shows the word ("Empty", "Red", etc). Everything was normal. Then I changed the name of a column and it stopped working ! I …
    Accepted
    14 6
    Accepted Answer 14 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • CountIf formula using Sheet Reference
    In Formulas and Functions
    Im trying to do a CountIF conditional formula using to columns in a referenced sheet. I"m trying to only count the open Risks. So Status1 is Type (Risk, Issue) Status2 is Status (Open, Closed) This is what I have so far, but it's not…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Formulas and Functions