-
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…
-
Creating a IF(AND(ISDATE formula to check a box
Hi All, I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts. Goal: in my data set I dont care what the date is just that it is a date (anydate)…
-
Sumifs not working between cross sheets
I am trying to add up a value if 2 criteria are met. I want to add the value of "Change Order Amount" if "Owner Approval" is "Yes" and it is "Cost Code" "1-Overhead" HELP