nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Is there a formula that will work for this?

Darcie Wilson

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.

Find more posts tagged with

Formulas

Comments

Shaine Greenwood

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:

You'll need to modify the formula for each of your resources.
Change the column names in my example formula to the column names in your sheet.
You'll want to put this in a column that is formatted for percentages.

Let me know if you have any questions.

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Abnormal Display of Hyperlink Content in Notification Emails
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…