Best Of

Hi @RiseUpPNW

You need to change the First Name's formula to this;

=LEFT(Volunteer@row , FIND(" ", Volunteer@row ) - 1)

In English, find the space between the first name and last name. Get the string from the top up to position one before the found space position to get the first name.

https://app.smartsheet.com/b/publish?EQBCT=e1858249b1eb43d08b95fe92860b5cd5

I would insert a helper column that outputs the level

=COUNT(ANCESTORS())

Then you can leverage this in whatever other formula you are using to evaluate the levels.

=COUNTIFS(………………….., Level:Level, @cell = 2)

Hey Brandon, would this do the trick?

=SUMIFS({Upcoming Jobs (High Level) Range 3}, {Upcoming Jobs (High Level) Range 1}, OR(@cell = [Job Name 1]@row , @cell = [Job Name 2]@row , @cell = [Job Name 3]@row , @cell = [Job Name 4]@row ))

Hello KPH,

So…. I should probably be barred from sending updates on Monday mornings. You are absolutely right and I haven't been looking at this right, till now. I'm going to go do this a little more correctly and I'll get back to you. Sorry, but thank you for sticking with me!