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.