-
Nested IF formulas
Hello, I'm new round here. Please excuse the entry level ask. I have an array of 3x3 cells. In each row only 1 of the 3 cells will be completed and I want to return a value from another cell depending on which of 2 the 3 cells are blanks. I have these 3 formulas working as expected in isolation, but I am struggling to nest…
-
Filter by formula
I have several columns which I typically have a formula in nearly every row (like you would use a column formula) but I've decided to have the formula be cell based because every once in a while, I need to input a manual number instead of deriving from a formula. My current situation is that I'm using reference manager to…
-
Breakdown formula not working correctly
Hi All, So I've got this formula that automatically breaks hours down into respective columns based on dates: =IFERROR(IF(AND(VALUE(YEAR($[MDR Start]@row) + "" + IF(MONTH($[MDR Start]@row) < 10, "0") + MONTH($[MDR Start]@row)) <= [Jan-21]$1, VALUE(YEAR($Finish@row) + "" + IF(MONTH($Finish@row) < 10, "0") +…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
Nested IF formulas for status
I am trying to write a nested IF formula, but as I run it there is one argument that is not resulting as I expected. Basically what I want my Status column to represent is the following -Done: when a project is in 100% compliance -In Progress: when a project is anywhere from 1%-75% and its within the due date (the…
-
metric sheet and sumif formula
Hi I am having a tough time with a sumif formula on a metric sheet. =SUMIFS({Location # and Name 4}, LOCATION@row, {AP $ AMT POSTED}) I am wanting to count by location the $ in the AP $ AMT POSTED column. Any help is appreciated.
-
Shorter way to do this?
I am using a formula to change the value of one cells based on the values of some cells below it in a column. The formula that I'm using is working but I want to add it to some more places in the sheet, where it would get very long. Does anyone know a way I could abbreviate this? It is okay when there are only two cells…
-
Issue referencing VLOOKUP data in another formula
Hi, I have a VLOOKUP pulling in data from another sheet that will be updated on an ongoing basis. The data pulling in is the number of manufacturing days to complete an operation. The VLOOKUP function is working fine. This is the VLOOKUP formula: =VLOOKUP([Model Series]@row, {Mfg Hours by Model Range 1}, 7, false) Within…
-
Match Contact column list to Email Address
Has anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lot of manual intervention. The problem with Smartsheet Contacts is that people can…
-
Recommended roll-up scoring?
Hello all, I have a few different methods for scoring in Smartsheets but am wondering if there is recommended documentation or formulas, specifically, for scoring a parent status indicator (RYGB ball) based on its children. Of course, this depends on the definition of each status in context, but again I am asking for…