-
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…
-
Collapse rows for completed tasks
Any way we can get a row to collapse after the task is complete, similar to the "hide/unhide" feature in excel?
-
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…
-
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…