Formulas and Functions
Archives for April 2021
Discussion List
-
Changing an older cell based on criteria from a newer cellIn Formulas and FunctionsHello, 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…
-
Resolve Multi-Select Choices into single linesIn Formulas and FunctionsI 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 11 views 3 comments 0 points Most recent by Ronald Moyer Formulas and Functions
-
Can I nest more than one SUMIFIn Formulas and FunctionsI 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 11 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
VLOOKUP on a Multi DropDown ListIn Formulas and FunctionsI'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 46 views 6 comments 0 points Most recent by Bassam Khalil Formulas and Functions
-
Rozanne ReedyIn Formulas and FunctionsHow 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 11 views 2 comments 0 points Most recent by Rozanne Reedy Formulas and Functions
-
Count employees starting by a set dateIn Formulas and FunctionsHello, 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…
-
Help with Formula for Budget SpreadIn Formulas and FunctionsCan 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 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Index MatchIn Formulas and FunctionsHello 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?
-
Symbols don't appear anymore when used in a FormulaIn Formulas and FunctionsHi, 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 …
-
CountIf formula using Sheet ReferenceIn Formulas and FunctionsIm 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…
