I am working on a sheet to track the status of test cases and want to have the status of the subtask roll up to the parent status. The goal is that if 5 tasks are available and 2 "Passed", 1 "In Progr…
I am trying to create a report that tells me how many tasks have been completed in the last 5 days. Currently, I have a reporting field called child to make sure I only show children tasks and i also …
I would like to set up a formula that is based on a dropdown of the months. Q1 would be January to March. I have been looking at using the month's formula but realized that it works off of dates, not …
I am currently creating a project template that I wanted to add some automation into. The first piece of that automation is to change the RGYB using the finish date and % complete. The formula that I …
I currently have a sheet where i have multiple columns with dates thats that are going to need to roll up to the project level parent. I am looking for a way to roll the dates without using the predce…