-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Automatically autopopulate a cell from a cell in the same column based off the date in its row?
I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row? For example, can I have the Associate Healthcare number from last month automatically populate into the…
-
how to make decimals work?
Hi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example: =IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01) how can i multply with decimals? Thanks
-
Creating a COUNTIFS Formula within Multi-Select drop down column to get a % figure
Hi, I've created a tracker that captures information on the make ups of Boards. One column is called 'Diversity' and has the option to multi select either "BAME" or "Disability" What i'd like to be able to do is to Count the number of times either BAME or Disability is chosen and then divide that by the number of entries…
-
Formulas and functions in forms
Hi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the content of these two fields and then use logic to prompt new fields if content does…
-
Formula Woes
My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), @{Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19]$1, {Implementation Rollup Work Finish}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) >= [1/7/19]$1, {Implementation…
-
Checkbox formula with percentage
Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you!
-
Pulling data from a sheet
Good Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that records each persons errors for the whole year. I record data for about 30 individuals…