-
How to find a missing contact
I have a multi-contact column where I assign users to a task [Assigned To]. I have another column where one of the assigned users selects their contact once they have completed their portion of the task [Completed By]. I want an automation that sends a reminder/Update request to Assigned Users that have not Completed their…
-
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…