-
Changing an older cell based on criteria from a newer cell
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 Status of “Pass” and a new row is added, is it possible to change the original Status entry…
-
Resolve Multi-Select Choices into single lines
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 all these sheets. Columns are: Workgroup Impacted (multi-select) Project Name Event…
-
Can I nest more than one SUMIF
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 Risk (25%), Moderate Impact Risk (50%) or High Impact Risk (90%) Take the total amount…
-
VLOOKUP on a Multi DropDown List
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 sheet I have all the assets accounted for, each in their own row. I'm trying to use…
-
Rozanne Reedy
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.
-
Count employees starting by a set date
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 be less than or equal to the "Start by 5/1" in the example. Here is a rough start:…
-
Help with Formula for Budget Spread
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 have a START DATE column We would like to build a formula that would take a $100,000…
-
Index Match
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?
-
Symbols don't appear anymore when used in a Formula
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 tried to create new columns, or to use different symbols, even to make a copy of the sheet under a new…
-
CountIf formula using Sheet Reference
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 taking. Any suggestions? =COUNTIF(AND{PingOne Verify: Risk, Issues, & De... Range…
