Looking for formula to have auto numbers, that subtasks inherit the main task job number

tiaARCC

Hello,

I am looking for an auto number formula that will have subtasks created in card view auto inherit the parent's job number for every card created. My workplace has a very old sheet that I believe does this but in grid mode and I am not sure how to re-create the effect. The column is a text/number format instead of auto number type. And if it can auto collapse it would be helpful.

Thanks in advance!

Old sheet

Trying to set it up here.

Paul Newcome

You would need to put this formula in your Primary Column (it looks like your "Page" column in the second screenshot).

=IF(COUNT(ANCESTORS()) = 0, [Auto-Number Column Name]@row, PARENT([Auto-Number Column Name]@row))