Children Rows of an Auto number.

ShawnaK
ShawnaK ✭✭✭
in Formulas and Functions

I have the first column as an Autonumbered for requests. Some of the request will have sub requests and I am wondering if there is a way to create a child row without having a new autonumber generated.

image.png
· Share on FacebookShare on Twitter

Answers

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    If you are using an auto number column, then no, there is not a way. You could create a FAR Helper column where the column formula would be = PARENT([FAR Number]@row) and that would only ever display the parent row's number.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!