-
Merged: Collapse rows for completed tasks
This discussion has been merged.
-
Displaying %Complete Column on Metrics Sheet
Hello! My coworker and I think we are close to figuring out this formula on our Metrics Sheet but we keep receiving the "Incorrect Argument Set" message. Here's the formula in the screenshot: =INDEX(COLLECT({Per Complete}, {P2H Task}, $Reference@row , {Milestone}, 1)) {Per Complete} = the %Complete column in the source…
-
INDEX/MATCH Most Recent Entry
I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is…
-
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!
-
Planned % rollup formula giving higher % than % Complete
Hi Community, I’m trying to build a reliable Planned % column that rolls up consistently, so I can compare it against % Complete at the project and phase levels. Setup I created an Old Planned % column that calculates planned progress for each row based on Planned Start and Planned Finish dates: =IF(OR([Planned Start]@row…
-
index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
-
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,…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
Split Multiple Selections In Single Form Into Individual Columns
If I have an option on a form for a multi-date selection field is there a formula that could help break out each date selected into its own column. So if it was a sign up form and they wanted to select 3 dates to work then each date they are working could end in its own column. Then I could set a reminder automation based…