Hello, I have a formula that should be the same for all three calculations I am trying to do but two are giving an error when I think everything about them is the same. Here are the two formulas I am …
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into…
In my task sheet health column I am trying to write a formula that I desperately need help with. I have a column labeled status. It is a drop down column where I can select "Not Started", "In Progress…
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right co…
I want to check a box in my metadata sheet (restricted to checkbox column) if the overall health of my project is red. The referenced cell/column is restricted to symbols, green, yellow, and red circl…
I have two sheets that I need to compare data and highlight any matching data. If Sheet "A" query column matches any of the data in Sheet "B" query column, then the matching data in Sheet "B" query co…
Hello, I have successfully put together a formula to pull an Investigation tracking number to a cell when the product name on the new sheet matches the product name on the Investigation Tracker sheet.…
Hi, We have many live projects at any one time which all share cross functional resources. I want to create a report which shows all tasks, per week, on all projects. To do this I have added a column …
I know what it is, but I am trying to replicate it in a project plan. Every time I try to do it, the End Date of the project just gets pushed out, making negative float impossible. I'm wondering if th…
