Automation for creating Sub row in same sheet

Robert Hayman ✭✭

09/30/22 in Formulas and Functions

How can you setup an automation to create a subrow for a row once a condition is met? (such as a checkbox is marked in a row, and that triggers the creation of a sub row to that now parent row)

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Darren Mullen Community Champion

  09/30/22 Answer ✓

  @Robert Hayman Unfortunately not with the automation workflows on a sheet. You could do this through an API integration. I'm not sure if there are any out of the box solutions right now, but definitely if you wrote a custom script.

  Darren Mullen, join the Smartsheet Guru Elite

  Get my 7 Smartsheet tips here

  Author of: Smartsheet Architecture Solutions

  0 · Share on FacebookShare on Twitter

Answers

• 

  Darren Mullen Community Champion

  09/30/22 Answer ✓

  @Robert Hayman Unfortunately not with the automation workflows on a sheet. You could do this through an API integration. I'm not sure if there are any out of the box solutions right now, but definitely if you wrote a custom script.

  Darren Mullen, join the Smartsheet Guru Elite

  Get my 7 Smartsheet tips here

  Author of: Smartsheet Architecture Solutions

  0 · Share on FacebookShare on Twitter
• 

  Robert Hayman ✭✭

  09/30/22

  Thanks Darren! That is a little beyond my current skill set, but a great suggestion. I inherited an inventory smartsheet and am trying to find a way to have a "history" of each row/item.

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list