Can I auto number parent rows only?

Options

Hello,

I would like to have an auto-number created in a column called FO Number, however I only want the number created in parent rows, not their children.

The number also has to line up with a separate database I use and therefor needs to start at 1886 for the first job in my sheet.


eg. "VS-CL01GP407-B" will have FO number 1886 with all its children blank and "Part B - Plate"

will have FO number 1887.

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!