-
Subtotals on new column in Project Sheet
Hi, I have a project sheet on which I have added a column for expended hours. I would like that column to behave like the %completed column in that it auto subtotals through the project. Is there any way to do that? Edit: Fount it
-
Am stuck with an IF(AND formula
=IF(AND([% Complete]@row < 1, [End Date]@row > TODAY(), "Red", IF(AND([% Complete]@row < 1, [End Date]@row <= TODAY(), "Amber", "Green")))) which should mean (in my dreams :)) if under 100% and the date is past, then red if under 100% and the date is today and future, then amber otherwise green Where am I wrong please
-
Can a calendar view of a report reflect the formatting/formating of the underlying sheet or report
Hello everyone!! We use a sheet to schedule staff for events. We have about 30 to 50 of those folks. We use the update request for them to accept or not. We are in a fast-paced industry where things change often and rapidly. To help them continuously see where they stand, I have built a report for each person. I then have…
-
#INCORRECT ARGUMENT error
Hi (again!) From other answers I've found here I'm guessing this is a parenthesis issue but I can't work out which ones. =COUNTIF({Clinical Trials : Accepted Range 1}, >=TODAY(), {Clinical Trials : Accepted Range 2}, HAS(@cell, "Blacktown")) Trying to sort current contracts (expiry date today or later) by research site ie:…
-
Pulling data dynamically from standard project folders
We found a template for multiple projects that uses a standard folder setup to keep Reports, Project Plan and Dashboards for each project within its own project folder... allowing us to have the separate lists of tasks and RFI's, rollups organized for each project rather than a forever-growing list of entries from old…
-
Formula to exclude expired dates
I'd like to count how many "current" contracts we have My reference sheet has a column for estimated end date, I just can't find the right formula to exclude dates that fall prior to todays date Thanks!
-
Formula to exclude expired years
Hi Hi, I'd like to count how many "current" contracts we have and also how many we have up coming close to expiry (say in the next 60 days) My reference sheet has a column for estimated end date, I just can't find the right formula to exclude dates that fall prior to the current date. And I have no idea how to write the…
-
INVALID DATA TYPE error
Hi, I'm trying to count the cells that match these criteria but am getting an invalid data type error. =COUNTIFS(OR({Tier}, "Experiencia", {Tier}, "Experiencia Plus", {Tier}, "Experiencia Plus Unlimited"), {Renewal Month}, 1, {Renewal Year}, 2023) The formula worked successfully without the OR statement: =COUNTIFS({Tier},…
-
CountIF formula with added criteria - NEED TO KNOW HOW TO ADD
I am trying to obtain counts with multiple criteria, I have tried looking at other solutions that do not work. This is my formula - =COUNTIFS({iPro Site Type}, $[Primary Column]@row, {iPro Region}, [Column2]$42) I need to understand how to add an additional criteria - I want it to return the count of all sites types per…
-
Countifs from one sheet with multiple categories
I need to complete a countifs formula for data in one sheet with multiple categories (screenshots of data needed). The columns that need to be counted have different drop-down options. I have to count active status defects the total (New, open, Assigned, Ready for Retest, Assigned to Vendor, Reopened) for each module. The…
