-
Formula to calculate numbers of checked/unchecked occurrences in dashboard
I'm trying to create a dashboard widget that shows the our number of media articles by project, broken into those that mention our organisation vs those that only mention the project. Something along these lines, but instead of "Totals" / "Column 3" these would be RDA Mention / Project Mention I created the above using…
-
#Invalid Data Type issue
Hello! I have a sheet that is calculating completed projects YTD for each Project Manager. I have used the following sheet summary formula for 6 PMs, and it seems to work correctly, but when I used it for the 7th PM it gives me the #INVALID DATA TYPE error. I can't figure out what the difference is. Below are the two…
-
Formula to Evaluate Multi-Selection and Sum Individual Associated Values
I may be asking too much in terms of formula functionality, but here is my goal / question: I have the following columns: Item - These are items that can be selected by the user, multiple items are allowed Price - Price per item User Selection - Received from a form Total Cost - The cost of the selection(s) I am using an…
-
Index/Match vs Index/Collect vs Index/Contains
Creating a sheet to collect and answer FAQs, I am attempting to populate the System/Tech Supporting SME dependent upon the selected system/technology. I have my primary collection sheet and then I have made a reference sheet for some formulas. Relevant columns with fake data from the primary collection sheet. System/Tech…
-
How to Display Images in a Destination Sheet Using Formulas
This discussion was created from comments split from: Is there any way to bring an image from a sheet to another sheets?.
-
Circular reference options
Discovered I can't use a formula in the same column I want to populate data back into. How can I use a helper column and where do I place the formula. Tried this formula but get circular reference =IF(OR(ISBLANK([Original Due Date]@row), [Original Due Date]@row = ""), [Due Date]@row, [Original Due Date]@row) I can't have a…
-
Project Status Formula and Checklist items
We have a project checklist template that is provisioned via Control Center. There are hidden columns (the "Task Not Needed" referenced in the formula) that show only the checklist for the Project Type selected in intake - the tasks that are not supposed to appear are checked because all the project-specific checklists…
-
Help with cross cell referencing
I have a sheet of incidents that I want to be able to count the number of certain types in a month. In my incident sheet I have a column called "Type of Incident", that has values of Safety, Environment and Quality A column for the date, that I have used formulas in helper columns to get the Month and year. So now a cell…
-
Status Rollup to Parent Formula
Hi, I have this formula that works when automating parent/child tasks in a project plan. =IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@row)), "Complete", IF(COUNTIF(CHILDREN(formula@row), "Not Started") = COUNT(CHILDREN(formula@row)), "Not Started", "In…
-
Return values from another sheet based on specific conditions
Hi All, Can anyone help me by return selected columns of data from another sheet? I already use COUNTIFS formula to count the total project number in 2021 is 5, and is there any formula that can automatically generate the project code, requester, and project location from the raw data? Here is the raw data Not sure if…
