Child Cell Formatting
I would like for child cells to automatically appear for each new row, and then have an index/match formula be able to populate a column in the parent row from those child rows.
For example: New air freight request- 5 child rows with default values of the 5 carriers pop up (can't do a dropdown, I need to track the 5 carriers data over time), and then when I enter the quote numbers from each carrier and pick a carrier, it auto-populates the quote amount into the parent row.
I'm not sure if this is a functionality of Smartsheet. I would prefer to not have to manually create the rows and type them out each time, but I can if necessary.
Help Article Resources
Check out the Formula Handbook template!