-
Formula for impact score x likelihood
Hi i currently have the below formula but need help amending this =IF([Impact Score]@row = "", "", [Impact Score]@row * [Likelihood Score]@row I need to amend this for if column type is risk then impact score* likelihood score and if column type is issue then return impact score only Thanks
-
DataMesh: What if the lookup value column is a formula?
I have a sheet to track travel, which includes a Start Location column and End Location column, and a third "Start - End" column which contains a formula that combines the first two columns. I've done this so that I can reference another sheet, which has the estimated cost from Location A to B, using DataMesh. However,…
-
Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
-
Merged: Collapse rows for completed tasks
This discussion has been merged.
-
SUMIFS with date and category referencing another sheet
Hi - I have a cashflow chart that I want to pull expenses into by category and month. The expenses are located on another sheet with a dropdown list that is the same on the cashflow chart. I have tried this formula but it is not returning the results - just $0.00 =SUMIFS({Expenses Amount}, {Expenses Category},…
-
How to record a date in a gantt?
Hi, I have a question about the Gantt chart. I want to record a date (start date) when a row is added. This will ensure that when a row is added to the Gantt chart, the start date is recorded at the beginning of the Gantt chart, and the other dates are automatically calculated. Is this possible? Regards
-
How to collect multiple Successor values?
Here's a link to my initial post which helped get me this far. RECAP: I use a combination of a Successor formula & Join/Collect in an attempt to report for my team the next tasks and assignee(s) in our waterfall workflow. I am able to successfully return the next assignee only when there is a single successor. I need to…
-
Help me brainstorm with my staffing calculation Issue.
Hi all, So, help me out here i'll state the facts and the current case here. I need a staffing calculation every hour per zone. Data is received every 15 minutes through a shuttle. Below you can see the current process. Don't mind the red square and mark. Data is being updated in box and moved to smartsheet with a data…
-
Help with addition to formula
Hi, i need to make an addition to the below formula please. I need to add if column type is issue and impact score is 4 - gray, 3 - red, 2, amber and 1 green =IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >=…
-
How to Have Children Rows Updated based on Data from Parent Row
I am setting up a sheet which will have many parent rows with many children connected to them. There is a column called "Escalated to AM?" which is a drop-down with the option to select "Escalated". There is another column called "Escalated?", which is a checkbox column. I want to add a formula to the "Escalated?" checkbox…