-
Calculating a percentage based on YTD wins
Hi everyone - I'm trying to add a percentage of wins to a dashboard. Initially I thought the easiest solution would be to add a formula to the sheet summary page and i used this but have been getting back #invalid Data Type error. =COUNTIFS([Status/Conclusion]:[Status/Conclusion], "Won", YEAR([Date Requested]:[Date…
-
Date Formula Not Working?
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
-
Change date color beyond certain time period
Hello! This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed. For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like…
-
Leading Zero in DD-Mon-YYYY
Can there be an option to enable the front Zero for the date format 27-Apr-2018? Right now it will show only a single digit for days 1-9, and the Zero is needed to make the numbers unambiguous. (I didn't make this rule, just have to follow it.)
-
How to create a time stamped column with the date
How do I create a time stamp column to auto populate the date and time of when a cell changed from blank to a value? The workflow to fill in a date does not provide the time and I cannot figure out a formula that would capture both date and time?
-
Modified Date column not working
I have always done a 'save as new' with all of my sheets to archive data and then changed the Created Date column to Modified Date, that way it keeps the original created date of the rows in the archived version. However recently the Modified date is not changing, it is just mirroring what the created date field is. What…
-
Using If/or/and to change date based on different drop downs and checkmark selections
Hi all, Adding on to an existing formula to automatically add a number of days depending if a column is checked or not. The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the…
-
Formula to add 1 day to date
I'm having trouble with a formula to add one day to a date based on a condition. I'm sure it is something terribly simple that I'm just missing right now. My formula worked previously when I had AND in the formula with two conditions, but when I only have one condition it adds a 1 to the end of the date rather than adding…
-
I want to know the formula, if I want the total breakdowns from 1/1/2025?
In my sheet, I have a "Job" column, where it indicates if it was a breakdown or installation. I have a "Date of Job" column, but this goes from 2022. My goal is to calculate the total breakdowns for every year.
-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…