-
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…
-
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?
-
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…
-
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 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…
-
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
-
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…
-
Warnings when approaching functional sheet capacity
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
-
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…
-
Last working day of the current month
I need some help with the following formula: =WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0) The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025). Can someone tell me what is wrong with the formula that it's not giving me a date?