-
Calculating pro-rated values for every month
In the below schedule of values, the $ value of each child task is the parent value multiplied by a weight. For forecasting purposes, let us assume that 25th of every month, each line item is billed depending on the whether the start and finish dates fall within the period. In the below example, activity on Row 20, is to…
-
Having trouble with IF(AND
I have 2 columns of dates; Column a = Target Date Column b = Actual Date I want to turn a cell 'Red' if Actual Date is blank and Target Date is either today or past. The above formular returns 'INCORRECT ARGUMENT SET'.
-
Formula to collect resource's start date
Hello, I am trying to create a formula that will collect the min. date for the resource listed at row for various projects. If the resource isn't listed as a task owner, Right now, I am getting a blank response instead of my initial start date for a project. Current Formula: =IFERROR(IF(CONTAINS(Resource@row, {Task…
-
Level Formula Not Working
Hi! I have been using the same level formula for a while, but for some reason on a newly created sheet, my formula isn't working, and I can't figure out why. Here is a screenshot of the relevant columns: The formula I've entered is: =(IF(COUNT(CHILDREN([Study Protocol]@row)) > 0, COUNT(ANCESTORS([Study Protocol]@row)) +…
-
Auto Fill with Dates if certain category is selected
I am trying to figure out how to have certain cells auto fill with a generated date if a certain category is selected. Example: If "communication" is selected, I need a cell to auto fill with a date that is a week earlier than the "due date" column. Is there a way to do this? Thank you!
-
Count Data Based on Values in 2 columns
Hello, I am trying to input a formula to count data in a column if certain criteria are not met in another column. I cannot seem to get it right. This is what I have: =COUNTIFS({Qty. Res. Planner 2023 Range 1} CONTAINS("I", @cell)), AND{Qty. Res. Planner 2023 Jan 22} NOT(CONTAINS("OUT", @cell))) I have data in column 1 and…
-
I want to calculate the number of days using two date fields, and if blank use today.
I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know how many days from today - Build Start Date
-
Change Status Ball for Old Row Entry When New Entry of Same Name is Created
I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to…
-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
-
Status Auto Fill if due date passes
I am trying to figure out how to have a "status" change to past due if the due date occurs and the status is not "complete." Is there a way to do this? Thank you!