-
COUNT function linked to another sheet
I have a sheet that captures outstanding items for a set of 5 projects that we use to drive weekly status update meetings. I want to create a chart in our dashboard that shows the number of tasks for each project, and possibly one that shows how many have a status of "at risk" or "overdue" which are columns on my sheet.…
-
Read Only Mode
I'm facing a strange issue, i've created a mastersheet with around 5000rwos and 3500rows have data on it and those rows linked to another four sheets for particular data, now if i open my mastersheet it shows "we weren't able to load your sheet's cell links and had to make your sheet read only for now. sorry about the…
-
Need help merging repeated sub tasks with schedule steps
I am trying to figure out a way to merge high-level schedule steps with more granular tracker steps without having to build a whole new, super repetitive template. I have a master schedule that lists out all of the tasks for a project at the chapter level. However, each chapter breaks down into multiple parts, and those…
-
Error Check - Combining multiple IF/AND statements for calculation based status.
Hello, hope you are having a great day, I have issues using IF/AND combinations in formulae. I am trying to get a status off the percentage calculated in a different field (percentage value) and keep getting this error that says - #INCORRECT ARGUMENT SET This is my Formula- Details8 is the field where the percentage is…
-
Harvey Ball
You can see in this formula the Status (harvey ball) column defaults to Blue. It changes colors to Green, Yellow and Red with conditions from the Risk Rating Level column and it works perfect. However, I want the harvey ball to turn Red if the Risk Rating Level is Extreme even if the Complete checkbox is checked.…
-
Improve cell link formula
While doing the cell link formulas, one of the columns shows data even if the key identifier used is blank (Client ID), would you know why is it happening? but when the client ID column is filled, the column/row were able to update/pull the correct data. here's the formula I used: =INDEX({Client View Sales Region},…
-
Index/match cross sheet formula to account for misspelled data entry on source sheet
I'm attempting to figure out a solution for misspellings in the source sheet that I am referencing. I get #invalid value when the source sheet has misspellings. I do not control data entry on the source sheet and we have been unsuccessful with attempts to request misspellings be corrected so I am hoping there is a way for…
-
IF statement for multiple IDs
I have a column with multiple IDs and I want to select specific IDs and "complete" = 1 else 0. My current formula is : =IF(CONTAINS("000", [GAP Status ID]@row, 1, IF(CONTAINS("010", [GAP Status ID]@row, 1, IF(CONTAINS("020", [GAP Status ID]@row, 1, IF(CONTAINS("100", [GAP Status ID]@row, 1, IF(CONTAINS("110", [GAP Status…
-
Return a task name that corresponds to the row in the predecessor column
Hi there - I'm trying to get the text of the Task Name to show up in a column called "Pre-Reqs" that corresponds to the row number in the Predecessor column. I created a Row ID column, bc there's no easy way to reference rows. I've tried lookup and if statements and can't get it to work. Please help!
-
Need help with whether to use Datamesh or Formula
I have a sheet that we would like to pull info from another sheet and I'm having difficulty figuring out the best way to do it. My target sheet has a bulletin that refers to several TOPP numbers. I would like to pull email addresses from source sheet for those TOPP numbers listed in target sheet. I can figure out how to do…