Help to identify all x.x.1 cells

melmcdtsp

I have a WBS column that I'm joining with a resource row count to provide a distinction for tasks not just by hierarchy but by resource. I need to be able to exclude the very first task per assignee in the first hierarchy only. How do I identify only the x.x.1 tasks in a column? I need to create a formula for all RBS = x.x.1 rows to be blank.

Jennifer Kurtz

Hi, @melmcdtsp —

I think you could use the RIGHT function to identify the x.x.1 rows, as I think "1" would always be the rightmost number.

For example a column with this formula, =IF(RIGHT(RBS@row, 1) = 1, "", RBS@row) would be blank for rows that were x.x.1, and would populate the RBS for other rows. Alternately, you could use something similar in a checkbox column to identify the rows…

Does that help?

melmcdtsp

@Jennifer Kurtz - yes - thank you. Been too knee deep on the functioning in this sheet.

melmcdtsp

@Jennifer Kurtz - is there any way I can use a formula to identify with a checkbox the first task per assignee under each parent after the first group? I don't have a numbering system that helps for that nor will the tasks be as obvious as in

my picture.

Paul Newcome

The RIGHT function would also pull "1", "1.1", "1.1.111111", etc..

Do you already have a column that outputs the row number?

Jennifer Kurtz

Ah, right — @Paul Newcome! thank you; I missed this :S @melmcdtsp, tagging you again so that you can see Paul's note and adjust how you're identifying those rows accordingly.

Regarding identifying the first task per user, can you describe how you'd identify which those rows would be? If you can articulate the criteria you use to identify those rows, then it's likely possible to build a formula to do it for you.