Trending in Formulas and Functions
-
Percent Complete of Status Column
I am looking to have the Parent row show the sum of percent complete for children in the status column. Based on the photo attached, the formula I am using is not calculating the "Activity 1" cells being marked complete. I am using the formula: =COUNTIFS(CHILDREN([Status]@row), "Complete") / COUNT(CHILDREN([Status]@row))
-
Find the latest time entry and send a reminder if theres no entries in the future
Hi. I have built a form for our HR department to log their whereabouts for the following week. The team also receive an automated reminder every Wednesday to submit 5 entries (one row = 1 day) for each day of the following week. They simply advance the date field and select their whereabouts for each day. Although this is…
-
COUNTIF referencing another sheet and based on weight - can't get it to work
Hello, I am working on a capacity worksheet for my team. Essentially I am taking information from 8 different backlogs to calculate how much work has been assigned to them and comparing that against their capacity so we are able to see if they are under/over/correctly allocated. What I am trying to do is from my Capacity…