Sign in to join the conversation:
Please see attached screenshot
In a separate field (that I haven’t yet created), I would want to know the % availability (based on 40hr work week) of each assigned resource based on each active request status.
Hi Darcie,
You might need to test this out a bit more extensively, but I was able to come up with a formula for resource allocation based on your sheet:
=SUMIFS([Est Hours]:[Est Hours], [Assigned To]:[Assigned To], "Person A", [Request Status]:[Request Status], OR(@cell = "In Process", @cell = "Approved By Mgr")) / 40
This summarizes all of the estimated hours of projects that have been approved and are assigned to "Person A." It then divides them by 40 to give you their percent allocation.
A few notes on this:
Let me know if you have any questions.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
I'm officially stumped. I'm tracking Admissions Reps visits to schools, the types of visits and the amount of visits and inquiries. The columns are as follows: Created Date Rep Name Type of Event 1 - Dropdown: Tabletop, College Fair, Classroom Presentation, School Visit, School Tour District 1 - Dropdown with all Districts…
