-
Help with formula for schedule health
Hello, looking for some help with calculating schedule health. I have added a symbols column (Green, yellow, red, gray circles) called schedule health to schedule. I have started creating a formula to calculate the schedule health for each row. This is what I have based the formula on: On Track = Green. Occurs when ‘%…
-
IF / AND / #INCORRECT ARGUMENT SET - Formula Help
I'm trying to assign a "Status" column of Not Started, In Progress, Overdue, Complete, or Not Applicable (if a box in another column is checked), and am getting an error of #INCORRECT ARGUMENT SET. Appreciate any help. I've spent way too much time on this. :-) =IF([% Complete]@row = 1, "Complete", IF([Task Not…
-
Auto Populate Children Dates based on the parent first day of the month
Good evening - I am looking to create an auto date that maxes based on the month (i.e. 28 days in February or 30 days in September) based on the parent row. I originally had it by calendar year and organized by the Month as the parent, and that parent row has several values that are linked to other sheets, however, I was…
-
IF/AND/OR Nested Health for Checkboxes
Thank you Community as I thought I had this from all your previous questions, but I am still receiving an Incorrect Argument Set error for this one. =IF(AND([Database Complete]@row, 1, [Enabled Interface]@row, 1, [Charges Flowing]@row, 1), "Green", IF(OR(AND([Database Complete]@row, 0, [Enabled Interface]@row, 0, [Charges…
-
Pre-chosen date based upon name chosen
Hey all. Is it possible to set template date(s) in a group of cells when another cell drop down is selected? For instance, If I choose from a drop down "June 2024" the dates cells next to this would snap to certain dates (milestones) automatically. Trying to have x4 milestone dates snap when a "Month Year" is selected. Can…
-
Convert decimals (fractions) to hours and minutes
Can anyone provide a simple formula to convert decimals/fractions to hours and minutes?
-
How do I fix this formula
I need to this column to populate with the symbol from column Health if Customer Dashboard column has a checkmark. What am I doing wrong here?
-
Auto populate date from helper sheet based on certain criteria
Hi All, Having a heck of a time with a helper sheet and formula. If I type in a date, ex: 1/31/2023, I would like another column to populate a date that is before that 1/31/2022 date The kicker is I need that date to be a specific day that I have listed on a helper sheet elsewhere (dates on the left "Board Meeting Dates")…
-
How to use multiple IF and AND functions for symbol formula
Hello Everyone, I have a basic project sheet with Start Date, End Date, % Complete Columns. I would like a formula for Symbols to do the following: Gray = If todays date is less than Start Date Red = If todays date is greater than due date AND % Complete is less than 100 Yellow = If todays date is less than due date AND %…
-
Duplicate Row Column Formula?
Is there any way to flag a duplicate (only for the 2nd, 3rd, etc. duplicate)? I'd like to leave the first of an item but flag the multiples of the rows so that those can be deleted. =IF(COUNTIF([Task ID]$1:[Task ID]@row, [Task ID]@row) <> 1, 1, 0) is the formula I'm currently using but I want to have it setup as a column…
