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



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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!