-
Formula Help
Not easy to relay what i'm trying to do here... I'm trying to establish a resource requirement list. We have 13 resources available for 4 categories. Right now, I have each category set to cap at 13 resources based on volume per category(this can happen as these are fed via a separate formula). My issue is that I don't…
-
Help on formula: Nested ifs
Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (these are the subtasks) because of any of the listed reasons, it will be reflected in…
-
Formula for projects due to start in X no. of days
Hi again, Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error. Please don't get confused with the formula. The projects I created have 5 subtasks and as an alternative solution,…
-
Count Task Status across Sheets
For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total number of tasks which are Red or Yellow. I can easily create the report which shows the list of individual tasks which are…
-
Struggling with If statement
I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. Here is what I have, that is not working: =IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1))) Estimated Close Date is a date column. The formula I am trying to…
-
% Complete Auto-fill / Default value 0%
Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-filled on the newly inserted row as expected (ex: At Risk flag, Project, other columns…
-
Convert text date, to date 2018-04-18
I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field. The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot find a formula to do that. Any help? thanks d
-
Formula cell limit
Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
-
Automate Formula Criterion
I'm sorry if the answer to my question is available. I could not find information about automating a scheduled update criterion included in a formula. For a monthly dashboard, I created a series of formulas to count the number of topics at various development stages, total days in each stage, and the cycle time between…
-
Automatic Target %Completion by Date
Hello, I'm trying to configure a column to reflect the Target % Completion based on days from Finish date but am hitting a snag for Finish Dates that have passed (resulting in a percentage higher than 100) or Start Dates that haven't arrived yet (resulting in a negative percentage). (I do understand that you can't add a…