-
Formula to change a parent row cell based on the values in the child rows.
Hello. I am trying to create a formula to change the parent cell based on the values in the child cells. The cell values are blank, "Met" or "Unmet". Once all the child rows have the value of "Met" I need the parent row to change to "Met" and if any of the child rows have the value of "Unmet" or "blank" I need the parent…
-
Auto refresh formula fields in a report
When you try to update the value of the cell that will trigger the calculated fields in your Report, it will automatically update on the sheet but it doesn’t reflect in your Report as you have to refresh it before seeing the updated value. Please always automatically refresh the Report to see the updated value of the…
-
How do I subtract "break" time from my Time Tracking Columns?
I'm pretty far along on what I would have thought would be a normal function for a spreadsheet application called "Smart!" Anyway, I need to figure out the last steps in subtracting the break from the total hours worked. It shouldn't be hard as they are one of the following: 0:15; 030; 0:45 & 0:00 or 1:00, whichever that…
-
Error in WEEKDAY formula
I'm struggling with a formula that seems to be broken. I created a timesheet that has a cell that looks at the Auto Date/Time stamp and calls up the weekday. The formula is as follows: =WEEKDAY([Date/Time]129) It works great...unless the timestamp is 5:00PM or later. Then it results in the next day. So if the timestamp is…
-
Renumbering Children
I am trying to figure out how to set up a column that would set a child's number. If the parent has 5 children then the numbering would be 1-5. If you inserted a child between 2 & 3 then that new record would become 3 and the rest would be 4-6. I know I have to count the children but I am not sure how to identifies the…
-
Formula help with multiple variables
I would like to use a different sheet to aggregate data for the purposes of creating a dashboard. I am trying to determine the number of minutes a person spends on a specific task for a specific month. For example, I would like to know how many minutes Jane spent on emails in the month of January. Sheet column headers are:…
-
Count Summary Formula Question
Hello, Can anyone tell me what formula I would use if I want to count certain criteria based on criteria in another column? I want to be able to add tiles to my dashboard the number of internal and client meetings based on if the client confirmed. I have a column for Confirmed by client - Yes/No I have another column for…
-
Countifs with multiple criteria and a "combo" criteria
Hi! I am trying to figure out what I am doing wrong with the below...the formula works until I add the last part "=date(2023,3,14+{Sprint Push}, 1" =COUNTIFS({Target Complete}, =DATE(2023, 3, 28), {Parent/Header Column}, 0, {Early/Late Complete}, "", {Target Complete}, =DATE(2023, 3, 14) + {Sprint Push}, 1) I want to count…
-
How can I write a countif formula formula for a cell that contains multiple entries?
I have been struggling to get a countifs formula to match what I've created on a report so that I can display it on a dashboard. I want to count the number of times our team has had a call on specific topic with our clients. In some cases the conversation covers multiple topics and we log what was covered on the call over…
-
Formula not Pulling Time Stamp Time post 7:00PM Central Standard, Why?
I have a [Time] Column with a formula that uses SUBSTITUTE() and DATEONLY() to pull only the time from a timestamp column. =SUBSTITUTE([Start Time (Timestamp)]@row, DATEONLY([Start Time (Timestamp)]@row), "") It works fine for any timestamp that occurs prior to 7:00PM, after that time, it pulls the date as well. I also…
