Dynamic Formula for WORKDAY

Hi all,

I've been learning a lot about Dynamic Formulas and they are fantastic.

My question is, I have a formula:

Formula:

Please Login or Register  to view this content.

I would like for this formula to by dynamic so that it fills in as columns B and C are filled in.

I know I can do

Formula:

Please Login or Register  to view this content.

and copy that down, but then the spreadsheet slows down because that formula is copied down 50,000 times which it has to calculate each time something changes.

I tried the "CONTROL SHIFT ENTER" thing to just put the original formula into the dynamic brackets, but that doesn't appear to work (it does not filter down when data is present in B and C).

Any other options here?

haha... okay, that's fair.

Question though... I did try to use the LET function... so I have:

Formula:

Please Login or Register  to view this content.

Yet, when I hit enter, it does not filter down... and I know that's a dynamic function.

Sample workbook showing the LET function is attached.

Great, thank you!!!

FYI, the purpose of that formula is to give a start date, based upon the user's priorities. So, in this case, it's taking Gru's priorities and backing up the start dates the more priorities he has. It then updates if you change any of the names below.

My thought is, the formula looks at B3, and then goes down the rest of B to find any other Gru's. As it does, it adds the hours up of any successive Gru's and subtracts those hours from the due date to give a start date (provided the priorities are always in order, which they should always be.)

So, as you'd move that down column D, it would pick up B4, B5, etc. down the line.

I'm open for any suggestions that work better than that! As long as the formula gives a start date based upon the priorities of each user, that's the end goal. I *think* that formula does that (at least in my testing), I just can't seem to get it to be dynamic so it spills with the rest of the data.

If this matters or helps, Columns A, B, and C are dynamic in the real spreadsheet using the Filter function. I'm just trying to get the start date to keep up with those filters as the data is added / changes.

some expected results would help but, based on your relative referencing, perhaps something along the lines of:

Formula:

Please Login or Register  to view this content.

modify A3:C10 as needed (consider using dynamic range, or using FILTER etc)

Looks like that works... I'll figure out how to modify data, but thanks for the assist. I love this community!