-
Formula to tick a box if two conditions in another sheet are true.
Hi, I am trying to use a formula to tick a box in Sheet 1 if the following conditions are true: The email at row (Text Contact) in Sheet 1 matches the Email in the deployment sheet (Email Deployment) and the Event in the deployment sheet (Event Deployment) is equal to "Event Name". The event column in the deployment sheet…
-
how to make a sum for each day automatically ?
as you can see in the picture bellow, I want to make a function to generate an auto sum for each day where any time day changes, I get the sum directly of the same day. P.S: numbers in DailySum are random and for AmountIQD it has this function =[مجموع الاليات]@row + [مجموع العمالة]@row + [مجموع المواد]@row your help is…
-
Military Time
I have a column that the time input is in 24 hour time, but my staff will use 0700 instead of 07:00. Can I create a formula that will change 0700 to 07:00?
-
Can I use the formula COUNTIF to give me the number of hires by week?
Hi, I have my COUNTIF formula started to show the total number of hires in each category type however I need to further break it down by week. Ideally showing the number of hires within the next 7 days per category. I am feeding this sheet into a metric widget on a dashboard for others to view and would like to not have to…
-
"Last Update" to look for last manual update, not last formula update
I currently have a column that counts how many days until the due date. Because this column formula utilizes "TODAY()", this means the column re-calculates every single day. Because of this, my "Last Updated" auto-fill column always lists today (or the last day I opened the sheet) as the time the rows were last updated. Is…
-
Calculate duration between two times
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
-
basic formula im sure, but Im new to this
I am trying to write a formula that says the if the end date is before today that it selects the "Late" option out of the drop down in Status. I got most of the way there but keep getting an error. HELP
-
Formula to sum children rows into parent row
Hi Is there a formula to add up total hours for children into Parent row cell? Also to add earliest local start time and earliest local finish time in parent header?
-
Need formula to dynamically populate multiple rows from cross-sheet reference
I need to create a sheet that dynamically displays all projects assigned to me from another sheet called "Project Request Intake & Validation." Requirements: The sheet must update in real-time (if a project is removed from the source sheet, it should disappear from my sheet automatically) Each assigned project should…
-
INDEX Collect Max without blank
I am working on a formula to pull the row data from column "A", based on the criteria for row "B" and "C". The criteria is to look for the highest value in Column "B" and the same row "is not blank" in Column "C". In short index the row in column A, with the highest value in column B, that is also not blank in column C. I…